View: OKL_SO_QUOTE_DTLS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_SO_QUOTE_DTLS_UV

View Text

SELECT CHR.ID ID
, CHR.ID DNZ_CHR_ID
, CHR.ID CHR_ID
, GVE.CHR_ID_REFERRED CHR_ID_REFERRED
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRT.DESCRIPTION DESCRIPTION
, CHR.STS_CODE STS_CODE
, CHR2.CONTRACT_NUMBER MASTER_LEASE_CONTRACT
, KHR.PDT_ID PDT_ID
, PDT.NAME PRODUCT_NAME
, KHR.TERM_DURATION TERM_DURATION
, CHR.START_DATE START_DATE
, KHR.EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE
, KHR.ACCEPTED_DATE ACCEPTANCE_DATE
, CHR3.CONTRACT_NUMBER PROGRAM_NUMBER
, CHR.CURRENCY_CODE CURRENCY_CODE
, KHR.KHR_ID KHR_ID
, RUL.RGP_ID RGP_ID
, RUL.ID RUL_ID
, RUL.RULE_INFORMATION1 FREQUENCY
, RUL.RULE_INFORMATION2 ARREARS
, RUL.RULE_INFORMATION3 TAX
, GVE.ID ML_ID
, STST.MEANING STATUS
, RUL2.RULE_INFORMATION1 EFFECTIVE_FROM
, RUL2.RULE_INFORMATION2 EFFECTIVE_TO
, RUL2.ID SOQVDATE_RULE_ID
, KHR.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, KHR.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TO_CHAR(KHR.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
FROM OKC_K_HEADERS_B CHR
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_ALL_B CHR2
, OKC_K_HEADERS_ALL_B CHR3
, OKC_GOVERNANCES GVE
, OKL_PRODUCTS PDT
, OKC_STATUSES_TL STST
, OKC_RULES_B RUL
, OKC_RULES_B RUL2
WHERE CHR.SCS_CODE = 'QUOTE'
AND CHR.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHR.ID = KHR.ID
AND CHR.ID = GVE.CHR_ID (+)
AND GVE.CHR_ID_REFERRED = CHR2.ID (+)
AND CHR2.SCS_CODE (+) = 'MASTER_LEASE'
AND KHR.KHR_ID = CHR3.ID (+)
AND KHR.PDT_ID = PDT.ID (+)
AND CHR.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND CHR.ID = RUL.DNZ_CHR_ID(+)
AND RUL.RULE_INFORMATION_CATEGORY(+) = 'SOPAY'
AND CHR.ID = RUL2.DNZ_CHR_ID(+)
AND RUL2.RULE_INFORMATION_CATEGORY(+) = 'SOQVDATE'

Columns