Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_EXT_FA_HEADER_SOURCES_V |
SELECT FXH.HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, FXH.SOURCE_ID SOURCE_ID
, FXH.SOURCE_TABLE SOURCE_TABLE
, FXH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FXH.TRANS_NUMBER TRANS_NUMBER
, FXH.KHR_ID KHR_ID
, FXH.TRY_ID TRY_ID
, FXH.CONTRACT_NUMBER CONTRACT_NUMBER
, FXH.CUSTOMER_NAME CUSTOMER_NAME
, FXH.CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, BOOK_CLASSIFICATION_CODE BOOK_CLASSIFICATION_CODE
, PRODUCT_NAME PRODUCT_NAME
, TAX_OWNER_CODE TAX_OWNER_CODE
, REPRESENTATION_CODE REPRESENTATION_CODE
, REPRESENTATION_NAME REPRESENTATION_NAME
, FXH.RENT_IA_CONTRACT_NUMBER RENT_IA_CONTRACT_NUMBER
, FXH.RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER
, FXH.CONVERTED_NUMBER CONVERTED_NUMBER
, FXH.CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM
, FXH.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
, FXH.SALES_REP_NAME SALES_REP_NAME
, FXH.RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME
, FXH.RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME
, FXH.PO_ORDER_NUMBER PO_ORDER_NUMBER
, FXH.VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER
, FXH.RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE
, FXH.RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE
, FXH.ASSIGNABLE_FLAG ASSIGNABLE_FLAG
, FXH.CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG
, FXH.ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG
, FXH.KHR_ATTRIBUTE_CATEGORY KHR_ATTRIBUTE_CATEGORY
, FXH.KHR_ATTRIBUTE1 KHR_ATTRIBUTE1
, FXH.KHR_ATTRIBUTE2 KHR_ATTRIBUTE2
, FXH.KHR_ATTRIBUTE3 KHR_ATTRIBUTE3
, FXH.KHR_ATTRIBUTE4 KHR_ATTRIBUTE4
, FXH.KHR_ATTRIBUTE5 KHR_ATTRIBUTE5
, FXH.KHR_ATTRIBUTE6 KHR_ATTRIBUTE6
, FXH.KHR_ATTRIBUTE7 KHR_ATTRIBUTE7
, FXH.KHR_ATTRIBUTE8 KHR_ATTRIBUTE8
, FXH.KHR_ATTRIBUTE9 KHR_ATTRIBUTE9
, FXH.KHR_ATTRIBUTE10 KHR_ATTRIBUTE10
, FXH.KHR_ATTRIBUTE11 KHR_ATTRIBUTE11
, FXH.KHR_ATTRIBUTE12 KHR_ATTRIBUTE12
, FXH.KHR_ATTRIBUTE13 KHR_ATTRIBUTE13
, FXH.KHR_ATTRIBUTE14 KHR_ATTRIBUTE14
, FXH.KHR_ATTRIBUTE15 KHR_ATTRIBUTE15
, FXH.CUST_ATTRIBUTE_CATEGORY CUST_ATTRIBUTE_CATEGORY
, FXH.CUST_ATTRIBUTE1 CUST_ATTRIBUTE1
, FXH.CUST_ATTRIBUTE2 CUST_ATTRIBUTE2
, FXH.CUST_ATTRIBUTE3 CUST_ATTRIBUTE3
, FXH.CUST_ATTRIBUTE4 CUST_ATTRIBUTE4
, FXH.CUST_ATTRIBUTE5 CUST_ATTRIBUTE5
, FXH.CUST_ATTRIBUTE6 CUST_ATTRIBUTE6
, FXH.CUST_ATTRIBUTE7 CUST_ATTRIBUTE7
, FXH.CUST_ATTRIBUTE8 CUST_ATTRIBUTE8
, FXH.CUST_ATTRIBUTE9 CUST_ATTRIBUTE9
, FXH.CUST_ATTRIBUTE10 CUST_ATTRIBUTE10
, FXH.CUST_ATTRIBUTE11 CUST_ATTRIBUTE11
, FXH.CUST_ATTRIBUTE12 CUST_ATTRIBUTE12
, FXH.CUST_ATTRIBUTE13 CUST_ATTRIBUTE13
, FXH.CUST_ATTRIBUTE14 CUST_ATTRIBUTE14
, FXH.CUST_ATTRIBUTE15 CUST_ATTRIBUTE15
, FXH.REV_REC_METHOD_CODE REV_REC_METHOD_CODE
, FXH.INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE
, FXHL.LANGUAGE LANGUAGE
, FXHL.CONTRACT_STATUS CONTRACT_STATUS
, FXHL.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, FXH.CREATED_BY CREATED_BY
, FXH.CREATION_DATE CREATION_DATE
, FXH.LAST_UPDATED_BY LAST_UPDATED_BY
, FXH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FXH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FXH.CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, FXH.TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_CODE
, FXH.TERM_QUOTE_ACCEPT_DATE TERM_QUOTE_ACCEPT_DATE
, FXH.TERM_QUOTE_NUM TERM_QUOTE_NUM
, FXH.TERM_QUOTE_TYPE_CODE TERM_QUOTE_TYPE_CODE
, FXH.REPOSSESS_FLAG REPOSSESS_FLAG
, FXH.PARTY_ID PARTY_ID
, FXH.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM OKL_EXT_FA_HEADER_SOURCES_B FXH
, OKL_EXT_FA_HEADER_SOURCES_TL FXHL
WHERE FXH.HEADER_EXTENSION_ID = FXHL.HEADER_EXTENSION_ID