OKL Accept Quote
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLACCEPTQUOTE
DB package:
Source:
Short Name: OKLACCEPTQUOTE
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 TO_CHAR(sysdate, 'MM-DD-YYYY') SYSTEM_DATE, QA.ID QUOTE_ID, QA.QUOTE_NUMBER QUOTE_NUMBER, QA.QUOTE_TYPE QUOTE_TYPE, QA.QUOTE_STATUS QUOTE_STATUS, QA.QUOTE_REASON_DESCRIPTION QUOTE_REASON 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, QA.CONTRACT_END_DATE 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.DATE_SENT DATE_SENT, QT.DATE_REQUESTED QUOTE_CREATION_DATE, QA.COMMENTS COMMENTS, QA.CURRENCY CURRENCY, QA.RECIPIENT_ID RECIPIENT_ID, QA.RECIPIENT_NAME RECIPIENT_NAME, QT.LAST_UPDATED_BY REQUESTOR_ID, NVL(PPF.FULL_NAME,FU.USER_NAME) REQUESTOR QUOTE_ORG_ID ORG_ID, QA.AMOUNT QUOTE_TOTAL FROM OKL_AM_ASSET_QUOTES_UV QA, OKL_TRX_QUOTES_B QT, FND_USER FU, PER_PROPLE_F PPF WHERE QA.ID = :P_QUOTE_ID AND QAMT.QTE_ID = QA.ID AND FU.USER_ID = QT.LAST_UPDATED_BY AND FU.EMPLOYEE_ID = PPF.PERSON_ID(+) |