OKL Termination Quote

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLTERMQUOTE
DB package:
Run OKL Termination Quote and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Report - Vendor Residual Share ECC Lease Contracts, Lease Quote Summary OKL Termination Quotes OKL Inform Service and Maintenance Provider
Blitz Report™

Blitz Report™ provides multiple benefits: