VIEW: APPS.OKL_EXT_AP_HEADER_SOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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