OKL Termination Bill of Sale

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTERMBILLSALE
DB package:
Run OKL Termination Bill of Sale and other Oracle EBS reports with Blitz Report™ on our demo environment
  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'
Download
Related Blitz Reports
OKL Notify Title Filing Authority OKL Accept Quote OKL Termination Quote OKL Termination Quotes OKL Lease Shipping Instructions OKL Passthrough Transaction Activity OKL Report - Vendor Residual Share OKL Generate Quote Payment Schedule ECC Lease Contracts, Lease Quote Summary
Blitz Report™

Blitz Report™ provides multiple benefits: