Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_EXT_AP_HEADER_SOURCES_V |
SELECT PXH.HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, PXH.SOURCE_ID SOURCE_ID
, PXH.SOURCE_TABLE SOURCE_TABLE
, PXH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PXH.KHR_ID KHR_ID
, PXH.TRY_ID TRY_ID
, PXH.TRANS_NUMBER TRANS_NUMBER
, PXH.CONTRACT_NUMBER CONTRACT_NUMBER
, PXH.CUSTOMER_NAME CUSTOMER_NAME
, PXH.CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
, PXH.PRODUCT_NAME PRODUCT_NAME
, PXH.BOOK_CLASSIFICATION_CODE BOOK_CLASSIFICATION_CODE
, PXH.TAX_OWNER_CODE TAX_OWNER_CODE
, PXH.INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE
, PXH.REV_REC_METHOD_CODE REV_REC_METHOD_CODE
, PXH.SCS_CODE SCS_CODE
, PXH.CONVERTED_NUMBER CONVERTED_NUMBER
, PXH.CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM
, PXH.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
, PXH.SALES_REP_NAME SALES_REP_NAME
, PXH.PO_ORDER_NUMBER PO_ORDER_NUMBER
, PXH.VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER
, PXH.ASSIGNABLE_FLAG ASSIGNABLE_FLAG
, PXH.CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG
, PXH.ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG
, PXH.KHR_ATTRIBUTE_CATEGORY KHR_ATTRIBUTE_CATEGORY
, PXH.KHR_ATTRIBUTE1 KHR_ATTRIBUTE1
, PXH.KHR_ATTRIBUTE2 KHR_ATTRIBUTE2
, PXH.KHR_ATTRIBUTE3 KHR_ATTRIBUTE3
, PXH.KHR_ATTRIBUTE4 KHR_ATTRIBUTE4
, PXH.KHR_ATTRIBUTE5 KHR_ATTRIBUTE5
, PXH.KHR_ATTRIBUTE6 KHR_ATTRIBUTE6
, PXH.KHR_ATTRIBUTE7 KHR_ATTRIBUTE7
, PXH.KHR_ATTRIBUTE8 KHR_ATTRIBUTE8
, PXH.KHR_ATTRIBUTE9 KHR_ATTRIBUTE9
, PXH.KHR_ATTRIBUTE10 KHR_ATTRIBUTE10
, PXH.KHR_ATTRIBUTE11 KHR_ATTRIBUTE11
, PXH.KHR_ATTRIBUTE12 KHR_ATTRIBUTE12
, PXH.KHR_ATTRIBUTE13 KHR_ATTRIBUTE13
, PXH.KHR_ATTRIBUTE14 KHR_ATTRIBUTE14
, PXH.KHR_ATTRIBUTE15 KHR_ATTRIBUTE15
, PXH.CUST_ATTRIBUTE_CATEGORY CUST_ATTRIBUTE_CATEGORY
, PXH.CUST_ATTRIBUTE1 CUST_ATTRIBUTE1
, PXH.CUST_ATTRIBUTE2 CUST_ATTRIBUTE2
, PXH.CUST_ATTRIBUTE3 CUST_ATTRIBUTE3
, PXH.CUST_ATTRIBUTE4 CUST_ATTRIBUTE4
, PXH.CUST_ATTRIBUTE5 CUST_ATTRIBUTE5
, PXH.CUST_ATTRIBUTE6 CUST_ATTRIBUTE6
, PXH.CUST_ATTRIBUTE7 CUST_ATTRIBUTE7
, PXH.CUST_ATTRIBUTE8 CUST_ATTRIBUTE8
, PXH.CUST_ATTRIBUTE9 CUST_ATTRIBUTE9
, PXH.CUST_ATTRIBUTE10 CUST_ATTRIBUTE10
, PXH.CUST_ATTRIBUTE11 CUST_ATTRIBUTE11
, PXH.CUST_ATTRIBUTE12 CUST_ATTRIBUTE12
, PXH.CUST_ATTRIBUTE13 CUST_ATTRIBUTE13
, PXH.CUST_ATTRIBUTE14 CUST_ATTRIBUTE14
, PXH.CUST_ATTRIBUTE15 CUST_ATTRIBUTE15
, PXH.RENT_IA_CONTRACT_NUMBER RENT_IA_CONTRACT_NUMBER
, PXH.RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME
, PXH.RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE
, PXH.RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER
, PXH.RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME
, PXH.RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE
, PXH.INV_AGRMNT_NUMBER INV_AGRMNT_NUMBER
, PXH.INV_AGRMNT_EFFECTIVE_FROM INV_AGRMNT_EFFECTIVE_FROM
, PXH.INV_AGRMNT_PRODUCT_NAME INV_AGRMNT_PRODUCT_NAME
, PXH.INV_AGRMNT_CURRENCY_CODE INV_AGRMNT_CURRENCY_CODE
, PXH.INV_AGRMNT_SYND_CODE INV_AGRMNT_SYND_CODE
, PXH.INV_AGRMNT_POOL_NUMBER INV_AGRMNT_POOL_NUMBER
, PXH.CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, PXH.INV_AGRMNT_STATUS_CODE INV_AGRMNT_STATUS_CODE
, PXH.TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_CODE
, PXHL.LANGUAGE LANGUAGE
, PXHL.CONTRACT_STATUS CONTRACT_STATUS
, PXHL.INV_AGRMNT_STATUS INV_AGRMNT_STATUS
, PXHL.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, PXH.CREATED_BY CREATED_BY
, PXH.CREATION_DATE CREATION_DATE
, PXH.LAST_UPDATED_BY LAST_UPDATED_BY
, PXH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PXH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PXH.PARTY_ID PARTY_ID
, PXH.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_HEADER_SOURCES_TL PXHL
WHERE PXH.HEADER_EXTENSION_ID = PXHL.HEADER_EXTENSION_ID