OKL Accept Quote (1)

SELECT DISTINCT TO_CHAR(sysdate, 'MM-DD-YYYY')  SYSTEM_DATE,
       QA.ID QUOTE_ID,
       QA.QUOTE_NUMBER QUOTE_NUMBER,
       (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE ='OKL_QUOTE_TYPE' AND LANGUAGE = 'US' AND LOOKUP_CODE = QA.QUOTE_TYPE) QUOTE_TYPE,
       QA.QUOTE_STATUS QUOTE_STATUS,
       QA.QUOTE_REASON_DESCRIPTION QUOTE_REASON,
       QA.DATE_EFFECTIVE_FROM QUOTE_EFFECTIVE_FROMDISTI,
       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.DATE_SENT DATE_SENT,
       QT.DATE_REQUESTED QUOTE_CREATION_DATE,
       QA.COMMENTS COMMENTS,
       QA.CURRENCY_CODE 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_PEOPLE_F PPF
WHERE QA.ID= :P_QUOTE_ID
	AND QT.ID = QA.ID
	AND FU.USER_ID = QT.LAST_UPDATED_BY
	AND FU.EMPLOYEE_ID = PPF.PERSON_ID(+)
    AND PPF.EFFECTIVE_END_DATE >= sysdate