OKL Termination Quote

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTERMQUOTE
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT sysdate  SYSTEM_DATE,
       QA.ID QUOTE_ID,
       QA.QUOTE_NUMBER QUOTE_NUMBER,
       QA.QUOTE_TYPE_DESCRIPTION QUOTE_TYPE,
       QA.QUOTE_STATUS QUOTE_STATUS,
       QA.DATE_EFFECTIVE_FROM QUOTE_EFFECTIVE_FROM,
       QA.DATE_EFFECTIVE_TO QUOTE_EFFECTIVE_TO,
       QA.KHR_ID CONTRACT_ID,
       QA.CONTRACT_NUMBER CONTRACT_NUMBER,
       QA.CONTRACT_START_DATE CONTRACT_START_DATE,
       TO_CHAR(QA.CONTRACT_END_DATE, 'MM-DD-YYYY') CONTRACT_END_DATE,
       ROUND(MONTHS_BETWEEN(QA.CONTRACT_START_DATE,QA.CONTRACT_END_DATE)) CONTRACT_TERM,
       QA.CONTRACT_STATUS_MEANING CONTRACT_STATUS,
       QA.ASSET_NUMBER ASSET_NUMBER,
       QA.ASSET_DESCRIPTION ASSET_DESCRIPTION,
       QA.RECIPIENT_ID RECIPIENT_ID,
       QA.RECIPIENT_NAME RECIPIENT_NAME,
       QUOTE_ORG_ID ORG_ID,
       QA.AMOUNT QUOTE_TOTAL
FROM OKL_AM_ASSET_QUOTES_UV QA
WHERE QA.ID = :P_QUOTE_ID
Download
 
Related Blitz Reports
OKL Accept Quote OKL Notify Title Filing Authority OKL Termination Bill of Sale OKL Lease Shipping Instructions XLA Entity ID Mappings OKL Inform Service and Maintenance Provider ECC Lease Contracts, Contracts OKL Report - Vendor Residual Share ECC Lease Contracts, Lease Quote Summary
Blitz Report™

Blitz Report™ provides multiple benefits: