OKL Termination Bill of Sale

Description
Categories: BI Publisher
Columns: Asset Price, Quote Number, Date Requested, Date Effective To, Residual Value, Rent Amount, Date Accepted, Unbilled Receivables, Currency, Gain Loss ...
Application: Lease and Finance Management
Source:
Short Name: OKLTERMBILLSALE
DB package:
  SELECT TRQ.ASSET_VALUE                    ASSET_PRICE,
       TRQ.QUOTE_NUMBER                     QUOTE_NUMBER,
       TRQ.DATE_REQUESTED                   DATE_REQUESTED,
       TRQ.DATE_EFFECTIVE_TO                DATE_EFFECTIVE_TO,
       TRQ.RESIDUAL_VALUE                   RESIDUAL_VALUE,
       TRQ.RENT_AMOUNT                      RENT_AMOUNT,
       TRQ.DATE_ACCEPTED                    DATE_ACCEPTED,
       TRQ.UNBILLED_RECEIVABLES             UNBILLED_RECEIVABLES,
       TRQ.CURRENCY_CODE                    CURRENCY,
       TRQ.GAIN_LOSS                        GAIN_LOSS,
       TRQ.PERDIEM_AMOUNT                   PERDIEM_AMOUNT,
       TRQ.DATE_APPROVED                    DATE_APPROVED,
       QUV.RECIPIENT_NAME                   CUSTOMER,
       QUV.QUOTE_STATUS_DESCRIPTION         QUOTE_STATUS,
       QUV.QUOTE_REASON_DESCRIPTION         QUOTE_REASON,
       QUV.QUOTE_TYPE_DESCRIPTION           QUOTE_TYPE,
       QUV.CONTRACT_NUMBER                  CONTRACT_NUMBER,
       QUV.CONTRACT_START_DATE              CONTRACT_START_DATE,
       QUV.CONTRACT_END_DATE                CONTRACT_END_DATE,
       QUV.CONTRACT_STATUS_MEANING          CONTRACT_STATUS
FROM OKL_TRX_QUOTES_V TRQ,
     OKL_AM_QUOTES_UV QUV
WHERE TRQ.ID =  :P_QUOTE_ID
AND TRQ.ID = QUV.ID
AND QUV.QUOTE_PARTY_ROLE = 'RECIPIENT'