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_AR_HEADER_SOURCES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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