View: OKL_AP_PAYMENTS_REF_V

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

View Text

SELECT AID.INVOICE_DISTRIBUTION_ID OKL_INVOICE_DISTRIBUTION_ID
, PXH.KHR_ID OKL_KHR_ID /* CHR RELATED SOURCES */
, PXH.CONTRACT_NUMBER TEH_CONTRACT_NUMBER
, PXH.CONVERTED_NUMBER TEH_CONVERTED_NUMBER
, PXH.CONTRACT_EFFECTIVE_FROM TEH_CONTRACT_EFFECTIVE_FROM
, PXH.CONTRACT_STATUS_CODE TEH_CONTRACT_STATUS_CODE
, PXH.PO_ORDER_NUMBER TEH_PO_ORDER_NUMBER /* PRODUCT
AND PRODUCT QUALITY VALUES INFORMATION */
, PXH.PRODUCT_NAME TCN_CONTRACT_PRODUCT_NAME
, PXH.BOOK_CLASSIFICATION_CODE TCN_BOOK_CLASSIFICATION_CODE
, PXH.REV_REC_METHOD_CODE TEH_REV_REC_METHOD_CODE
, PXH.INT_CALC_METHOD_CODE TEH_INT_CALC_METHOD_CODE
, PXH.TAX_OWNER_CODE TCN_TAX_OWNER_CODE /* KHR RELATED SOURCES */
, PXH.ASSIGNABLE_FLAG TEH_ASSIGNABLE_FLAG
, PXH.CONVERTED_ACCOUNT_FLAG TEH_CONVERTED_ACCOUNT_FLAG /* CONTRACT DFF INFORMATION STORED ON KHR */
, PXH.KHR_ATTRIBUTE_CATEGORY TCN_ATTRIBUTE_CATEGORY
, PXH.KHR_ATTRIBUTE1 TCN_ATTRIBUTE1
, PXH.KHR_ATTRIBUTE2 TCN_ATTRIBUTE2
, PXH.KHR_ATTRIBUTE3 TCN_ATTRIBUTE3
, PXH.KHR_ATTRIBUTE4 TCN_ATTRIBUTE4
, PXH.KHR_ATTRIBUTE5 TCN_ATTRIBUTE5
, PXH.KHR_ATTRIBUTE6 TCN_ATTRIBUTE6
, PXH.KHR_ATTRIBUTE7 TCN_ATTRIBUTE7
, PXH.KHR_ATTRIBUTE8 TCN_ATTRIBUTE8
, PXH.KHR_ATTRIBUTE9 TCN_ATTRIBUTE9
, PXH.KHR_ATTRIBUTE10 TCN_ATTRIBUTE10
, PXH.KHR_ATTRIBUTE11 TCN_ATTRIBUTE11
, PXH.KHR_ATTRIBUTE12 TCN_ATTRIBUTE12
, PXH.KHR_ATTRIBUTE13 TCN_ATTRIBUTE13
, PXH.KHR_ATTRIBUTE14 TCN_ATTRIBUTE14
, PXH.KHR_ATTRIBUTE15 TCN_ATTRIBUTE15 /* CUSTOMER ACCOUNT NUMBER */
, PXH.CUST_ACCOUNT_NUMBER TEH_CUSTOMER_ACCOUNT_NUMBER /* NOT APPLICABLE SOURCES
, PXH.CONTRACT_CURRENCY_CODE TEH_CONTRACT_CURRENCY_CODE
, PXH.ACCRUAL_OVERRIDE_FLAG TEH_ACCRUAL_OVERRIDE_FLAG */ /* CUSTOMER DFF INFORMATION */
, PXH.CUST_ATTRIBUTE_CATEGORY TEH_CUST_ATTRIBUTE_CATEGORY
, PXH.CUST_ATTRIBUTE1 TEH_CUST_ATTRIBUTE1
, PXH.CUST_ATTRIBUTE2 TEH_CUST_ATTRIBUTE2
, PXH.CUST_ATTRIBUTE3 TEH_CUST_ATTRIBUTE3
, PXH.CUST_ATTRIBUTE4 TEH_CUST_ATTRIBUTE4
, PXH.CUST_ATTRIBUTE5 TEH_CUST_ATTRIBUTE5
, PXH.CUST_ATTRIBUTE6 TEH_CUST_ATTRIBUTE6
, PXH.CUST_ATTRIBUTE7 TEH_CUST_ATTRIBUTE7
, PXH.CUST_ATTRIBUTE8 TEH_CUST_ATTRIBUTE8
, PXH.CUST_ATTRIBUTE9 TEH_CUST_ATTRIBUTE9
, PXH.CUST_ATTRIBUTE10 TEH_CUST_ATTRIBUTE10
, PXH.CUST_ATTRIBUTE11 TEH_CUST_ATTRIBUTE11
, PXH.CUST_ATTRIBUTE12 TEH_CUST_ATTRIBUTE12
, PXH.CUST_ATTRIBUTE13 TEH_CUST_ATTRIBUTE13
, PXH.CUST_ATTRIBUTE14 TEH_CUST_ATTRIBUTE14
, PXH.CUST_ATTRIBUTE15 TEH_CUST_ATTRIBUTE15 /* CUSTOMER RELATED INFOMRATION */
, PXH.CUSTOMER_NAME TEH_CUSTOMER_NAME /* RENT
, RESIDUAL
AND INV AGRMNT SOURCES */
, PXH.RENT_IA_CONTRACT_NUMBER TEH_RENT_IA_CONTRACT_NUMBER
, PXH.RENT_IA_PRODUCT_NAME TEH_RENT_IA_PRODUCT_NAME
, PXH.RENT_IA_ACCOUNTING_CODE TEH_RENT_IA_ACCOUNTING_CODE /* RESIDUAL INVESTOR AGREEMENT SOURCES */
, PXH.RES_IA_CONTRACT_NUMBER TEH_RES_IA_CONTRACT_NUMBER
, PXH.RES_IA_PRODUCT_NAME TEH_RES_IA_PRODUCT_NAME
, PXH.RES_IA_ACCOUNTING_CODE TEH_RES_IA_ACCOUNTING_CODE /* VENDOR PROGRAM SOURCES */
, PXH.SALES_REP_NAME TEH_SALES_REP_NAME /* VENDOR PROGRAM AGREEMENT */
, PXH.VENDOR_PROGRAM_NUMBER TEH_VENDOR_PROGRAM_NUMBER /* OTHER SOURCES */
, PXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, PXL.ASSET_CATEGORY_NAME TEL_ASSET_CATEGORY_NAME
, PXL.INVENTORY_ITEM_NAME_CODE TEL_INVENTORY_ITEM_NAME_CODE
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_LINE_SOURCES_B PXL
, AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_INVOICE_LINES_ALL AIL
, OKL_TXL_AP_INV_LNS_ALL_B TAL
WHERE PXH.SCS_CODE = 'LEASE'
AND PXH.HEADER_EXTENSION_ID = PXL.HEADER_EXTENSION_ID
AND PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B'
AND PXL.SOURCE_ID = TAL.ID
AND AID.INVOICE_ID = AIL.INVOICE_ID
AND AID.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
AND AIL.APPLICATION_ID = 540
AND AIL.PRODUCT_TABLE = 'OKL_TXL_AP_INV_LNS_ALL_B'
AND AIL.REFERENCE_KEY1 = TAL.ID

Columns