View: OKL_AR_REC_APP_KHR_REF_V

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

View Text

SELECT ARAPP.RECEIVABLE_APPLICATION_ID OKL_REC_APP_ID
, RXL.SOURCE_ID OKL_TXD_ID
, RXH.KHR_ID OKL_KHR_ID
, RXL.KLE_ID OKL_KLE_ID
, RXH.TRY_ID OKL_TRY_ID
, RXL.STY_ID TCL_STY_ID
, RXH.TRANS_NUMBER TCN_TRX_NUMBER
, RXH.CONTRACT_NUMBER TEH_CONTRACT_NUMBER
, RXH.PRODUCT_NAME TCN_CONTRACT_PRODUCT_NAME
, RXH.BOOK_CLASSIFICATION_CODE TCN_BOOK_CLASSIFICATION_CODE
, RXH.TAX_OWNER_CODE TCN_TAX_OWNER_CODE
, RXH.RENT_IA_CONTRACT_NUMBER TEH_RENT_IA_CONTRACT_NUMBER
, RXH.RES_IA_CONTRACT_NUMBER TEH_RES_IA_CONTRACT_NUMBER
, RXH.CONVERTED_NUMBER TEH_CONVERTED_NUMBER
, RXH.CONTRACT_EFFECTIVE_FROM TEH_CONTRACT_EFFECTIVE_FROM
, RXH.CONTRACT_CURRENCY_CODE TEH_CONTRACT_CURRENCY_CODE
, RXH.SALES_REP_NAME TEH_SALES_REP_NAME
, RXH.RENT_IA_PRODUCT_NAME TEH_RENT_IA_PRODUCT_NAME
, RXH.RES_IA_PRODUCT_NAME TEH_RES_IA_PRODUCT_NAME
, RXH.PO_ORDER_NUMBER TEH_PO_ORDER_NUMBER
, RXH.VENDOR_PROGRAM_NUMBER TEH_VENDOR_PROGRAM_NUMBER
, RXH.RENT_IA_ACCOUNTING_CODE TEH_RENT_IA_ACCOUNTING_CODE
, RXH.RES_IA_ACCOUNTING_CODE TEH_RES_IA_ACCOUNTING_CODE
, RXH.ASSIGNABLE_FLAG TEH_ASSIGNABLE_FLAG
, RXH.CONVERTED_ACCOUNT_FLAG TEH_CONVERTED_ACCOUNT_FLAG
, RXH.ACCRUAL_OVERRIDE_FLAG TEH_ACCRUAL_OVERRIDE_FLAG
, RXH.TERM_QUOTE_ACCEPT_DATE TEH_TERM_QUOTE_ACCEPT_DATE
, RXH.TERM_QUOTE_NUM TEH_TERM_QUOTE_NUM
, RXH.TERM_QUOTE_TYPE_CODE TEH_TERM_QUOTE_TYPE_CODE
, RXH.KHR_ATTRIBUTE_CATEGORY TCN_ATTRIBUTE_CATEGORY
, RXH.KHR_ATTRIBUTE1 TCN_ATTRIBUTE1
, RXH.KHR_ATTRIBUTE2 TCN_ATTRIBUTE2
, RXH.KHR_ATTRIBUTE3 TCN_ATTRIBUTE3
, RXH.KHR_ATTRIBUTE4 TCN_ATTRIBUTE4
, RXH.KHR_ATTRIBUTE5 TCN_ATTRIBUTE5
, RXH.KHR_ATTRIBUTE6 TCN_ATTRIBUTE6
, RXH.KHR_ATTRIBUTE7 TCN_ATTRIBUTE7
, RXH.KHR_ATTRIBUTE8 TCN_ATTRIBUTE8
, RXH.KHR_ATTRIBUTE9 TCN_ATTRIBUTE9
, RXH.KHR_ATTRIBUTE10 TCN_ATTRIBUTE10
, RXH.KHR_ATTRIBUTE11 TCN_ATTRIBUTE11
, RXH.KHR_ATTRIBUTE12 TCN_ATTRIBUTE12
, RXH.KHR_ATTRIBUTE13 TCN_ATTRIBUTE13
, RXH.KHR_ATTRIBUTE14 TCN_ATTRIBUTE14
, RXH.KHR_ATTRIBUTE15 TCN_ATTRIBUTE15
, RXH.CUST_ATTRIBUTE_CATEGORY TEH_CUST_ATTRIBUTE_CATEGORY
, RXH.CUST_ATTRIBUTE1 TEH_CUST_ATTRIBUTE1
, RXH.CUST_ATTRIBUTE2 TEH_CUST_ATTRIBUTE2
, RXH.CUST_ATTRIBUTE3 TEH_CUST_ATTRIBUTE3
, RXH.CUST_ATTRIBUTE4 TEH_CUST_ATTRIBUTE4
, RXH.CUST_ATTRIBUTE5 TEH_CUST_ATTRIBUTE5
, RXH.CUST_ATTRIBUTE6 TEH_CUST_ATTRIBUTE6
, RXH.CUST_ATTRIBUTE7 TEH_CUST_ATTRIBUTE7
, RXH.CUST_ATTRIBUTE8 TEH_CUST_ATTRIBUTE8
, RXH.CUST_ATTRIBUTE9 TEH_CUST_ATTRIBUTE9
, RXH.CUST_ATTRIBUTE10 TEH_CUST_ATTRIBUTE10
, RXH.CUST_ATTRIBUTE11 TEH_CUST_ATTRIBUTE11
, RXH.CUST_ATTRIBUTE12 TEH_CUST_ATTRIBUTE12
, RXH.CUST_ATTRIBUTE13 TEH_CUST_ATTRIBUTE13
, RXH.CUST_ATTRIBUTE14 TEH_CUST_ATTRIBUTE14
, RXH.CUST_ATTRIBUTE15 TEH_CUST_ATTRIBUTE15
, RXH.REV_REC_METHOD_CODE TEH_REV_REC_METHOD_CODE
, RXH.INT_CALC_METHOD_CODE TEH_INT_CALC_METHOD_CODE
, RXL.ASSET_NUMBER TEL_ASSET_NUMBER
, RXL.CONTRACT_LINE_NUMBER TEL_CONTRACT_LINE_NUMBER
, RXL.ASSET_VENDOR_NAME TEL_ASSET_VENDOR_NAME
, RXL.INSTALLED_SITE_ID TEL_INSTALLED_SITE_ID
, RXL.FIXED_ASSET_LOCATION_NAME TEL_FIXED_ASSET_LOCATION_NAME
, RXL.MEMO_FLAG TEL_MEMO_FLAG
, RXL.SUBSIDY_NAME OKL_SUBSIDY_NAME
, RXL.SUBSIDY_PARTY_NAME OKL_SUBSIDY_PARTY_NAME
, RXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.FEE_TYPE_CODE TEL_FEE_TYPE_CODE
, RXL.CONTRACT_LINE_TYPE OKL_KHR_LINE_TYPE
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_ASSET_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE1
, NULL) TCL_ASSET_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE2
, NULL) TCL_ASSET_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE3
, NULL) TCL_ASSET_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE4
, NULL) TCL_ASSET_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE5
, NULL) TCL_ASSET_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE6
, NULL) TCL_ASSET_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE7
, NULL) TCL_ASSET_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE8
, NULL) TCL_ASSET_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE9
, NULL) TCL_ASSET_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE10
, NULL) TCL_ASSET_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE11
, NULL) TCL_ASSET_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE12
, NULL) TCL_ASSET_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE13
, NULL) TCL_ASSET_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE14
, NULL) TCL_ASSET_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE15
, NULL) TCL_ASSET_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_FEE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE1
, NULL) TCL_FEE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE2
, NULL) TCL_FEE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE3
, NULL) TCL_FEE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE4
, NULL) TCL_FEE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE5
, NULL) TCL_FEE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE6
, NULL) TCL_FEE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE7
, NULL) TCL_FEE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE8
, NULL) TCL_FEE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE9
, NULL) TCL_FEE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE10
, NULL) TCL_FEE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE11
, NULL) TCL_FEE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE12
, NULL) TCL_FEE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE13
, NULL) TCL_FEE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE14
, NULL) TCL_FEE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE15
, NULL) TCL_FEE_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_SERVICE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE1
, NULL) TCL_SERVICE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE2
, NULL) TCL_SERVICE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE3
, NULL) TCL_SERVICE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE4
, NULL) TCL_SERVICE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE5
, NULL) TCL_SERVICE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE6
, NULL) TCL_SERVICE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE7
, NULL) TCL_SERVICE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE8
, NULL) TCL_SERVICE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE9
, NULL) TCL_SERVICE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE10
, NULL) TCL_SERVICE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE11
, NULL) TCL_SERVICE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE12
, NULL) TCL_SERVICE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE13
, NULL) TCL_SERVICE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE14
, NULL) TCL_SERVICE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE15
, NULL) TCL_SERVICE_ATTRIBUTE15
, RXH.CONTRACT_STATUS_CODE TEH_CONTRACT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, RXL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
, RXL.INVENTORY_ORG_CODE TEL_INVENTORY_ORG_CODE
FROM AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_ACTIVITY_DETAILS ARL
, RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
WHERE ARAPP.RECEIVABLE_APPLICATION_ID = ARL.SOURCE_ID
AND ARL.SOURCE_TABLE = 'RA'
AND ARL.CUSTOMER_TRX_LINE_ID = RACTRL.CUSTOMER_TRX_LINE_ID
AND RACTRL.LINE_TYPE = 'LINE'
AND RACTRL.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
AND RACTRL.INTERFACE_LINE_ATTRIBUTE14 = RXL.SOURCE_ID
AND RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
AND RXH.SCS_CODE = 'LEASE' /* AS THIS REF. VIEW IS ONLY FOR CONTRACT BILLING*/
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID

Columns