[Home] [Help]
SELECT CTR.ID ID, CTR.CONTRACT_NUMBER CONTRACT_NUMBER, KHR.DEAL_TYPE DEAL_TYPE, CTR.AUTHORING_ORG_ID AUTHORING_ORG_ID, PDT.NAME PRODUCT_NAME, OKX.NAME CUSTOMER_NAME, CTR.CURRENCY_CODE CURRENCY_CODE, Okl_Generate_Accruals_PUB.CALCULATE_CNTRCT_REC(CTR.ID) RECEIVABLE_VALUE, Okl_Loss_Prov_PUB.CALCULATE_CAPITAL_BALANCE(CTR.ID, KHR.DEAL_TYPE) CAPITAL_BALANCE, KHR.GENERATE_ACCRUAL_OVERRIDE_YN GENERATE_ACCRUAL_OVERRIDE_YN, Okl_Accounting_Util.GET_LOOKUP_MEANING('OKL_BOOK_CLASS', KHR.DEAL_TYPE) DEAL_TYPE_MEANING, Okl_Accounting_Util.GET_LOOKUP_MEANING('YES_NO', KHR.GENERATE_ACCRUAL_OVERRIDE_YN,0,0) OVERRIDE_YN_MEANING, CTR.END_DATE END_DATE, KHR.TERM_DURATION TERM_DURATION FROM OKC_K_HEADERS_B CTR,OKL_K_HEADERS KHR,OKL_PRODUCTS PDT,OKC_K_PARTY_ROLES_B PTY,OKX_PARTIES_V OKX WHERE CTR.ID = KHR.ID AND CTR.STS_CODE IN ('APPROVED', 'BOOKED', 'UNDER REVISION', 'EVERGREEN') AND KHR.PDT_ID = PDT.ID AND CTR.ID = PTY.DNZ_CHR_ID AND PTY.RLE_CODE = 'LESSEE' AND PTY.OBJECT1_ID1 = OKX.ID1
SELECT CTR.ID ID
, CTR.CONTRACT_NUMBER CONTRACT_NUMBER
, KHR.DEAL_TYPE DEAL_TYPE
, CTR.AUTHORING_ORG_ID AUTHORING_ORG_ID
, PDT.NAME PRODUCT_NAME
, OKX.NAME CUSTOMER_NAME
, CTR.CURRENCY_CODE CURRENCY_CODE
, OKL_GENERATE_ACCRUALS_PUB.CALCULATE_CNTRCT_REC(CTR.ID) RECEIVABLE_VALUE
, OKL_LOSS_PROV_PUB.CALCULATE_CAPITAL_BALANCE(CTR.ID
, KHR.DEAL_TYPE) CAPITAL_BALANCE
, KHR.GENERATE_ACCRUAL_OVERRIDE_YN GENERATE_ACCRUAL_OVERRIDE_YN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS'
, KHR.DEAL_TYPE) DEAL_TYPE_MEANING
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, KHR.GENERATE_ACCRUAL_OVERRIDE_YN
, 0
, 0) OVERRIDE_YN_MEANING
, CTR.END_DATE END_DATE
, KHR.TERM_DURATION TERM_DURATION
FROM OKC_K_HEADERS_B CTR
, OKL_K_HEADERS KHR
, OKL_PRODUCTS PDT
, OKC_K_PARTY_ROLES_B PTY
, OKX_PARTIES_V OKX
WHERE CTR.ID = KHR.ID
AND CTR.STS_CODE IN ('APPROVED'
, 'BOOKED'
, 'UNDER REVISION'
, 'EVERGREEN')
AND KHR.PDT_ID = PDT.ID
AND CTR.ID = PTY.DNZ_CHR_ID
AND PTY.RLE_CODE = 'LESSEE'
AND PTY.OBJECT1_ID1 = OKX.ID1
|
|
|
|