VIEW: APPS.OKL_AP_PAYMENTS_IA_REF_V

Source

View Text - Preformatted

SELECT aid.invoice_distribution_id OKL_INVOICE_DISTRIBUTION_ID ,pxh.khr_id OKL_KHR_ID /* Investor Agreement Related Sources */ ,pxh.inv_agrmnt_number TEH_INV_AGRMNT_NUMBER ,pxh.inv_agrmnt_effective_from TEH_INV_AGRMNT_EFFECTIVE_FROM ,pxh.inv_agrmnt_status_code TEH_INV_AGRMNT_STATUS_CODE ,pxh.inv_agrmnt_product_name TCN_INV_AGRMNT_PRODUCT_NAME ,pxh.inv_agrmnt_currency_code TEH_INV_AGRMNT_CURRENCY_CODE ,pxh.inv_agrmnt_pool_number TEH_INV_AGRMNT_POOL_NUMBER ,pxh.inv_agrmnt_synd_code TEH_INV_AGRMNT_SYND_CODE ,pxl.stream_type_code TCL_STREAM_TYPE_CODE ,pxl.stream_type_purpose_code TCL_STREAM_TYPE_PURPOSE ,pxl.accounting_template_name DIST_ACCOUNTING_TEMPLATE_NAME ,pxl.memo_flag TEL_MEMO_FLAG ,pxh.trx_type_class_code TEH_TRX_TYPE_CLASS_CODE FROM okl_ext_ap_header_sources_b pxh ,okl_ext_ap_line_sources_b pxl ,ap_invoice_distributions_all aid ,ap_invoice_lines_all ail ,okl_txl_ap_inv_lns_all_b tal WHERE pxh.scs_code = 'INVESTOR' AND pxh.header_extension_id = pxl.header_extension_id AND pxl.source_table = 'OKL_TXL_AP_INV_LNS_B' AND pxl.source_id = tal.id AND aid.invoice_id = ail.invoice_id AND aid.invoice_line_number = ail.line_number AND ail.application_id = 540 AND ail.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B' AND ail.reference_key1 = tal.id

View Text - HTML Formatted

SELECT AID.INVOICE_DISTRIBUTION_ID OKL_INVOICE_DISTRIBUTION_ID
, PXH.KHR_ID OKL_KHR_ID /* INVESTOR AGREEMENT RELATED SOURCES */
, PXH.INV_AGRMNT_NUMBER TEH_INV_AGRMNT_NUMBER
, PXH.INV_AGRMNT_EFFECTIVE_FROM TEH_INV_AGRMNT_EFFECTIVE_FROM
, PXH.INV_AGRMNT_STATUS_CODE TEH_INV_AGRMNT_STATUS_CODE
, PXH.INV_AGRMNT_PRODUCT_NAME TCN_INV_AGRMNT_PRODUCT_NAME
, PXH.INV_AGRMNT_CURRENCY_CODE TEH_INV_AGRMNT_CURRENCY_CODE
, PXH.INV_AGRMNT_POOL_NUMBER TEH_INV_AGRMNT_POOL_NUMBER
, PXH.INV_AGRMNT_SYND_CODE TEH_INV_AGRMNT_SYND_CODE
, PXL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, PXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
, PXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, PXL.MEMO_FLAG TEL_MEMO_FLAG
, PXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_LINE_SOURCES_B PXL
, AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_INVOICE_LINES_ALL AIL
, OKL_TXL_AP_INV_LNS_ALL_B TAL
WHERE PXH.SCS_CODE = 'INVESTOR'
AND PXH.HEADER_EXTENSION_ID = PXL.HEADER_EXTENSION_ID
AND PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B'
AND PXL.SOURCE_ID = TAL.ID
AND AID.INVOICE_ID = AIL.INVOICE_ID
AND AID.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
AND AIL.APPLICATION_ID = 540
AND AIL.PRODUCT_TABLE = 'OKL_TXL_AP_INV_LNS_ALL_B'
AND AIL.REFERENCE_KEY1 = TAL.ID