VIEW: APPS.OKL_SO_QUOTE_DTLS_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'