Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AR_ADJ_KHR_REF_V |
SELECT AJL.RECEIVABLES_ADJUSTMENT_ID RECEIVABLES_ADJUSTMENT_ID
, AJL.ID OKL_AJL_ID
, RXH.KHR_ID OKL_KHR_ID
, RXL.KLE_ID OKL_KLE_ID
, RXH.TRY_ID OKL_TRY_ID
, RXL.STY_ID OKL_STY_ID
, RXH.TRANS_NUMBER OKL_TRANS_NUMBER
, RXH.CONTRACT_NUMBER OKL_CONTRACT_NUMBER
, RXH.PRODUCT_NAME OKL_PRODUCT_NAME
, RXH.BOOK_CLASSIFICATION_CODE OKL_BOOK_CLASSIFICATION_CODE
, RXH.TAX_OWNER_CODE OKL_TAX_OWNER_CODE
, RXH.RENT_IA_CONTRACT_NUMBER OKL_RENT_IA_CONTRACT_NUMBER
, RXH.RES_IA_CONTRACT_NUMBER OKL_RES_IA_CONTRACT_NUMBER
, RXH.CONVERTED_NUMBER OKL_CONVERTED_NUMBER
, RXH.CONTRACT_EFFECTIVE_FROM OKL_CONTRACT_EFFECTIVE_FROM
, RXH.CONTRACT_CURRENCY_CODE OKL_CONTRACT_CURRENCY_CODE
, RXH.SALES_REP_NAME OKL_SALES_REP_NAME
, RXH.RENT_IA_PRODUCT_NAME OKL_RENT_IA_PRODUCT_NAME
, RXH.RES_IA_PRODUCT_NAME OKL_RES_IA_PRODUCT_NAME
, RXH.PO_ORDER_NUMBER OKL_PO_ORDER_NUMBER
, RXH.VENDOR_PROGRAM_NUMBER OKL_VENDOR_PROGRAM_NUMBER
, RXH.RENT_IA_ACCOUNTING_CODE OKL_RENT_IA_ACCOUNTING_CODE
, RXH.RES_IA_ACCOUNTING_CODE OKL_RES_IA_ACCOUNTING_CODE
, RXH.ASSIGNABLE_FLAG OKL_ASSIGNABLE_FLAG
, RXH.CONVERTED_ACCOUNT_FLAG OKL_CONVERTED_ACCOUNT_FLAG
, RXH.ACCRUAL_OVERRIDE_FLAG OKL_KHR_ACCRUAL_OVERRIDE_FLAG
, RXH.TERM_QUOTE_ACCEPT_DATE OKL_TERM_QUOTE_ACCEPT_DATE
, RXH.TERM_QUOTE_NUM OKL_TERM_QUOTE_NUM
, RXH.TERM_QUOTE_TYPE_CODE OKL_TERM_QUOTE_TYPE_CODE
, RXH.KHR_ATTRIBUTE_CATEGORY OKL_KHR_ATTRIBUTE_CATEGORY
, RXH.KHR_ATTRIBUTE1 OKL_KHR_ATTRIBUTE1
, RXH.KHR_ATTRIBUTE2 OKL_KHR_ATTRIBUTE2
, RXH.KHR_ATTRIBUTE3 OKL_KHR_ATTRIBUTE3
, RXH.KHR_ATTRIBUTE4 OKL_KHR_ATTRIBUTE4
, RXH.KHR_ATTRIBUTE5 OKL_KHR_ATTRIBUTE5
, RXH.KHR_ATTRIBUTE6 OKL_KHR_ATTRIBUTE6
, RXH.KHR_ATTRIBUTE7 OKL_KHR_ATTRIBUTE7
, RXH.KHR_ATTRIBUTE8 OKL_KHR_ATTRIBUTE8
, RXH.KHR_ATTRIBUTE9 OKL_KHR_ATTRIBUTE9
, RXH.KHR_ATTRIBUTE10 OKL_KHR_ATTRIBUTE10
, RXH.KHR_ATTRIBUTE11 OKL_KHR_ATTRIBUTE11
, RXH.KHR_ATTRIBUTE12 OKL_KHR_ATTRIBUTE12
, RXH.KHR_ATTRIBUTE13 OKL_KHR_ATTRIBUTE13
, RXH.KHR_ATTRIBUTE14 OKL_KHR_ATTRIBUTE14
, RXH.KHR_ATTRIBUTE15 OKL_KHR_ATTRIBUTE15
, RXH.CUST_ATTRIBUTE_CATEGORY OKL_CUST_ATTRIBUTE_CATEGORY
, RXH.CUST_ATTRIBUTE1 OKL_CUST_ATTRIBUTE1
, RXH.CUST_ATTRIBUTE2 OKL_CUST_ATTRIBUTE2
, RXH.CUST_ATTRIBUTE3 OKL_CUST_ATTRIBUTE3
, RXH.CUST_ATTRIBUTE4 OKL_CUST_ATTRIBUTE4
, RXH.CUST_ATTRIBUTE5 OKL_CUST_ATTRIBUTE5
, RXH.CUST_ATTRIBUTE6 OKL_CUST_ATTRIBUTE6
, RXH.CUST_ATTRIBUTE7 OKL_CUST_ATTRIBUTE7
, RXH.CUST_ATTRIBUTE8 OKL_CUST_ATTRIBUTE8
, RXH.CUST_ATTRIBUTE9 OKL_CUST_ATTRIBUTE9
, RXH.CUST_ATTRIBUTE10 OKL_CUST_ATTRIBUTE10
, RXH.CUST_ATTRIBUTE11 OKL_CUST_ATTRIBUTE11
, RXH.CUST_ATTRIBUTE12 OKL_CUST_ATTRIBUTE12
, RXH.CUST_ATTRIBUTE13 OKL_CUST_ATTRIBUTE13
, RXH.CUST_ATTRIBUTE14 OKL_CUST_ATTRIBUTE14
, RXH.CUST_ATTRIBUTE15 OKL_CUST_ATTRIBUTE15
, RXH.REV_REC_METHOD_CODE OKL_REV_REC_METHOD_CODE
, RXH.INT_CALC_METHOD_CODE OKL_INT_CALC_METHOD_CODE
, RXL.ASSET_NUMBER OKL_ASSET_NUMBER
, RXL.CONTRACT_LINE_NUMBER OKL_CONTRACT_LINE_NUMBER
, RXL.ASSET_VENDOR_NAME OKL_ASSET_VENDOR_NAME
, RXL.INSTALLED_SITE_ID OKL_INSTALLED_SITE_ID
, RXL.FIXED_ASSET_LOCATION_NAME OKL_FIXED_ASSET_LOCATION_NAME
, RXL.MEMO_FLAG OKL_MEMO_FLAG
, RXL.SUBSIDY_NAME OKL_SUBSIDY_NAME
, RXL.SUBSIDY_PARTY_NAME OKL_SUBSIDY_PARTY_NAME
, RXL.ACCOUNTING_TEMPLATE_NAME OKL_AE_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.FEE_TYPE_CODE OKL_FEE_TYPE_CODE
, RXL.CONTRACT_LINE_TYPE OKL_CONTRACT_LINE_TYPE
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) OKL_ASSET_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE1
, NULL) OKL_ASSET_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE2
, NULL) OKL_ASSET_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE3
, NULL) OKL_ASSET_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE4
, NULL) OKL_ASSET_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE5
, NULL) OKL_ASSET_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE6
, NULL) OKL_ASSET_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE7
, NULL) OKL_ASSET_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE8
, NULL) OKL_ASSET_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE9
, NULL) OKL_ASSET_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE10
, NULL) OKL_ASSET_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE11
, NULL) OKL_ASSET_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE12
, NULL) OKL_ASSET_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE13
, NULL) OKL_ASSET_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE14
, NULL) OKL_ASSET_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE15
, NULL) OKL_ASSET_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) OKL_FEE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE1
, NULL) OKL_FEE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE2
, NULL) OKL_FEE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE3
, NULL) OKL_FEE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE4
, NULL) OKL_FEE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE5
, NULL) OKL_FEE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE6
, NULL) OKL_FEE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE7
, NULL) OKL_FEE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE8
, NULL) OKL_FEE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE9
, NULL) OKL_FEE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE10
, NULL) OKL_FEE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE11
, NULL) OKL_FEE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE12
, NULL) OKL_FEE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE13
, NULL) OKL_FEE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE14
, NULL) OKL_FEE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE15
, NULL) OKL_FEE_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) OKL_SERVICE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE1
, NULL) OKL_SERVICE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE2
, NULL) OKL_SERVICE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE3
, NULL) OKL_SERVICE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE4
, NULL) OKL_SERVICE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE5
, NULL) OKL_SERVICE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE6
, NULL) OKL_SERVICE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE7
, NULL) OKL_SERVICE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE8
, NULL) OKL_SERVICE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE9
, NULL) OKL_SERVICE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE10
, NULL) OKL_SERVICE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE11
, NULL) OKL_SERVICE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE12
, NULL) OKL_SERVICE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE13
, NULL) OKL_SERVICE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE14
, NULL) OKL_SERVICE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE15
, NULL) OKL_SERVICE_ATTRIBUTE15
, RXH.CONTRACT_STATUS_CODE OKL_CONTRACT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE OKL_TRX_TYPE_CLASS_CODE
, RXL.STREAM_TYPE_CODE OKL_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE OKL_STREAM_TYPE_PURPOSE_CODE
, RXL.INVENTORY_ORG_CODE OKL_INVENTORY_ORG_CODE
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
, OKL_TXL_ADJSTS_LNS_ALL_B AJL
WHERE RXH.SCS_CODE = 'LEASE' /* AS THIS REF. VIEW IS ONLY FOR CONTRACT BILLING*/
AND RXL.SOURCE_TABLE = 'OKL_TXL_ADJSTS_LNS_B'
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID
AND RXL.SOURCE_ID = AJL.ID