VIEW: APPS.OKL_AM_RESTRUCTURE_QUOTES_UV

Source

View Text - Preformatted

SELECT OTQ.ID, OTQ.KHR_ID, OTQ.QUOTE_NUMBER, OTQ.QTP_CODE, FL2.MEANING QUOTE_TYPE, OTQ.QST_CODE, FL1.MEANING QUOTE_STATUS, OTQ.DATE_EFFECTIVE_FROM, OTQ.DATE_EFFECTIVE_TO, OTQ.RENT_AMOUNT, OKF.START_DATE, OKF.END_DATE, OTQ.ACCEPTED_YN, OTQ.APPROVED_YN, OTQ.QRS_CODE, FL3.MEANING QUOTE_REASON, OTQ.TERM, OTQ.YIELD, OTQ.COMMENTS, OKF.CONTRACT_NUMBER, OTQ.CONSOLIDATED_QTE_ID CONSOLIDATED_QTE_ID, OTQ.CONSOLIDATED_YN CONSOLIDATED_YN, OTQ.PURCHASE_AMOUNT PURCHASE_AMOUNT, OTQ.PURCHASE_FORMULA PURCHASE_FORMULA, OTQ.DATE_RESTRUCTURE_START DATE_RESTRUCTURE_START, OTQ.DATE_RESTRUCTURE_END DATE_RESTRUCTURE_END, OTQ.ORG_ID ORG_ID, OTQ.POP_CODE_END POP_CODE_END, FL4.MEANING ACCEPTED_YN_MEANING FROM OKL_TRX_QUOTES_V OTQ,OKC_K_HEADERS_ALL_B OKF,FND_LOOKUPS FL1,FND_LOOKUPS FL2,FND_LOOKUPS FL3,FND_LOOKUPS FL4 WHERE FL1.LOOKUP_TYPE = 'OKL_QUOTE_STATUS' AND FL2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE' AND FL3.LOOKUP_TYPE = 'OKL_QUOTE_REASON' AND FL1.LOOKUP_CODE = OTQ.QST_CODE AND FL2.LOOKUP_CODE = OTQ.QTP_CODE AND FL3.LOOKUP_CODE = OTQ.QRS_CODE AND OTQ.QTP_CODE LIKE 'RES%' AND OTQ.KHR_ID = OKF.ID (+) AND FL4.LOOKUP_TYPE = 'OKL_YES_NO' AND FL4.LOOKUP_CODE = NVL(OTQ.ACCEPTED_YN,'N')

View Text - HTML Formatted

SELECT OTQ.ID
, OTQ.KHR_ID
, OTQ.QUOTE_NUMBER
, OTQ.QTP_CODE
, FL2.MEANING QUOTE_TYPE
, OTQ.QST_CODE
, FL1.MEANING QUOTE_STATUS
, OTQ.DATE_EFFECTIVE_FROM
, OTQ.DATE_EFFECTIVE_TO
, OTQ.RENT_AMOUNT
, OKF.START_DATE
, OKF.END_DATE
, OTQ.ACCEPTED_YN
, OTQ.APPROVED_YN
, OTQ.QRS_CODE
, FL3.MEANING QUOTE_REASON
, OTQ.TERM
, OTQ.YIELD
, OTQ.COMMENTS
, OKF.CONTRACT_NUMBER
, OTQ.CONSOLIDATED_QTE_ID CONSOLIDATED_QTE_ID
, OTQ.CONSOLIDATED_YN CONSOLIDATED_YN
, OTQ.PURCHASE_AMOUNT PURCHASE_AMOUNT
, OTQ.PURCHASE_FORMULA PURCHASE_FORMULA
, OTQ.DATE_RESTRUCTURE_START DATE_RESTRUCTURE_START
, OTQ.DATE_RESTRUCTURE_END DATE_RESTRUCTURE_END
, OTQ.ORG_ID ORG_ID
, OTQ.POP_CODE_END POP_CODE_END
, FL4.MEANING ACCEPTED_YN_MEANING
FROM OKL_TRX_QUOTES_V OTQ
, OKC_K_HEADERS_ALL_B OKF
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FND_LOOKUPS FL3
, FND_LOOKUPS FL4
WHERE FL1.LOOKUP_TYPE = 'OKL_QUOTE_STATUS'
AND FL2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE'
AND FL3.LOOKUP_TYPE = 'OKL_QUOTE_REASON'
AND FL1.LOOKUP_CODE = OTQ.QST_CODE
AND FL2.LOOKUP_CODE = OTQ.QTP_CODE
AND FL3.LOOKUP_CODE = OTQ.QRS_CODE
AND OTQ.QTP_CODE LIKE 'RES%'
AND OTQ.KHR_ID = OKF.ID (+)
AND FL4.LOOKUP_TYPE = 'OKL_YES_NO'
AND FL4.LOOKUP_CODE = NVL(OTQ.ACCEPTED_YN
, 'N')