eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_EXT_FA_HEADER_SOURCES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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