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