View: OKL_ACCRUAL_OVERRIDE_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_ACCRUAL_OVERRIDE_UV

View Text

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

Columns