VIEW: APPS.OKL_AM_QUOTE_HEADER_UV

Source

View Text - Preformatted

SELECT QTE.ID ID, QTE.QUOTE_NUMBER QUOTE_NUMBER, QTE.QTP_CODE QUOTE_TYPE, FND2.MEANING QUOTE_TYPE_DESCRIPTION, QTE.QST_CODE QUOTE_STATUS, FND1.MEANING QUOTE_STATUS_DESCRIPTION, QTE.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO, KHR.ID KHR_ID, CHR.CONTRACT_NUMBER CONTRACT_NUMBER, HZ.PARTY_NAME CUSTOMER, PROGRAM.CONTRACT_NUMBER PROGRAM, okl_am_util_pvt.get_party_name(KHR.ID, 'PRIVATE_LABEL', NULL) PRIVATE_LABEL, QTE.ORG_ID QUOTE_ORG_ID, QTE.ASSET_VALUE TOTAL_ASSET_VALUE, QTE.RESIDUAL_VALUE TOTAL_RESIDUAL_VALUE, QTE.UNBILLED_RECEIVABLES TOTAL_UNBILLED_RECEIVABLES, QTE.GAIN_LOSS GAIN_LOSS, okl_am_util_pvt.get_quote_amount (QTE.ID) AMOUNT, QTE.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM, QTE.CREATION_DATE QUOTE_CREATION_DATE, QTE.DATE_ACCEPTED DATE_ACCEPTED, okl_am_util_pvt.get_anticipated_bill(QTE.id) ANTICIPATED_BILL_AMOUNT FROM OKL_TRX_QUOTES_ALL_B QTE,OKC_K_HEADERS_ALL_B PROGRAM,FND_LOOKUPS FND1,FND_LOOKUPS FND2,HZ_PARTIES HZ,OKC_K_PARTY_ROLES_B KPR,OKC_K_HEADERS_B CHR,OKL_K_HEADERS KHR WHERE CHR.ID=KHR.ID AND PROGRAM.ID (+) = KHR.KHR_ID AND QTE.KHR_ID = KHR.ID AND FND1.LOOKUP_TYPE = 'OKL_QUOTE_STATUS' AND FND2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE' AND FND1.LOOKUP_CODE = QTE.QST_CODE AND FND2.LOOKUP_CODE = QTE.QTP_CODE AND HZ.PARTY_ID = KPR.OBJECT1_ID1 AND KPR.CHR_ID = KHR.ID AND KPR.JTOT_OBJECT1_CODE = 'OKX_PARTY' AND KPR.RLE_CODE = 'LESSEE'

View Text - HTML Formatted

SELECT QTE.ID ID
, QTE.QUOTE_NUMBER QUOTE_NUMBER
, QTE.QTP_CODE QUOTE_TYPE
, FND2.MEANING QUOTE_TYPE_DESCRIPTION
, QTE.QST_CODE QUOTE_STATUS
, FND1.MEANING QUOTE_STATUS_DESCRIPTION
, QTE.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, KHR.ID KHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, HZ.PARTY_NAME CUSTOMER
, PROGRAM.CONTRACT_NUMBER PROGRAM
, OKL_AM_UTIL_PVT.GET_PARTY_NAME(KHR.ID
, 'PRIVATE_LABEL'
, NULL) PRIVATE_LABEL
, QTE.ORG_ID QUOTE_ORG_ID
, QTE.ASSET_VALUE TOTAL_ASSET_VALUE
, QTE.RESIDUAL_VALUE TOTAL_RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES TOTAL_UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS GAIN_LOSS
, OKL_AM_UTIL_PVT.GET_QUOTE_AMOUNT (QTE.ID) AMOUNT
, QTE.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, QTE.CREATION_DATE QUOTE_CREATION_DATE
, QTE.DATE_ACCEPTED DATE_ACCEPTED
, OKL_AM_UTIL_PVT.GET_ANTICIPATED_BILL(QTE.ID) ANTICIPATED_BILL_AMOUNT
FROM OKL_TRX_QUOTES_ALL_B QTE
, OKC_K_HEADERS_ALL_B PROGRAM
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
, HZ_PARTIES HZ
, OKC_K_PARTY_ROLES_B KPR
, OKC_K_HEADERS_B CHR
, OKL_K_HEADERS KHR
WHERE CHR.ID=KHR.ID
AND PROGRAM.ID (+) = KHR.KHR_ID
AND QTE.KHR_ID = KHR.ID
AND FND1.LOOKUP_TYPE = 'OKL_QUOTE_STATUS'
AND FND2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE'
AND FND1.LOOKUP_CODE = QTE.QST_CODE
AND FND2.LOOKUP_CODE = QTE.QTP_CODE
AND HZ.PARTY_ID = KPR.OBJECT1_ID1
AND KPR.CHR_ID = KHR.ID
AND KPR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND KPR.RLE_CODE = 'LESSEE'