VIEW: APPS.OKL_AP_IA_REF_V

Source

View Text - Preformatted

SELECT pxl.source_id OKL_TPL_ID ,'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE ,pxh.khr_id OKL_KHR_ID ,pxl.kle_id OKL_KLE_ID ,pxh.try_id OKL_TRY_ID ,pxl.sty_id TCL_STY_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 WHERE pxh.scs_code = 'INVESTOR' AND pxl.source_table = 'OKL_TXL_AP_INV_LNS_B' AND pxh.header_extension_id = pxl.header_extension_id

View Text - HTML Formatted

SELECT PXL.SOURCE_ID OKL_TPL_ID
, 'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE
, PXH.KHR_ID OKL_KHR_ID
, PXL.KLE_ID OKL_KLE_ID
, PXH.TRY_ID OKL_TRY_ID
, PXL.STY_ID TCL_STY_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
WHERE PXH.SCS_CODE = 'INVESTOR'
AND PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B'
AND PXH.HEADER_EXTENSION_ID = PXL.HEADER_EXTENSION_ID