VIEW: APPS.OKL_AR_REC_APP_IA_REF_V

Source

View Text - Preformatted

SELECT arapp.receivable_application_id okl_rec_app_id ,rxl.source_id okl_txd_id ,rxh.khr_id okl_khr_id ,rxl.kle_id okl_kle_id ,rxh.try_id okl_try_id ,rxl.sty_id tcl_sty_id ,rxh.inv_agrmnt_number teh_inv_agrmnt_number ,rxh.inv_agrmnt_effective_from teh_inv_agrmnt_effective_from ,rxh.inv_agrmnt_product_name tcn_inv_agrmnt_product_name ,rxh.inv_agrmnt_currency_code teh_inv_agrmnt_currency_code ,rxh.inv_agrmnt_synd_code teh_inv_agrmnt_synd_code ,rxh.inv_agrmnt_pool_number teh_inv_agrmnt_pool_number ,rxh.inv_agrmnt_status_code teh_inv_agrmnt_status_code ,rxh.trx_type_class_code teh_trx_type_class_code ,rxl.accounting_template_name dist_accounting_template_name ,rxl.contingency_code okl_contingency_code ,rxl.memo_flag tel_memo_flag ,rxl.stream_type_code tcl_inv_stream_type_code ,rxl.stream_type_purpose_code tcl_inv_stream_type_purpose FROM ar_receivable_applications_all arapp ,ar_activity_details arl ,ra_customer_trx_lines_all ractrl ,okl_ext_ar_header_sources_b rxh ,okl_ext_ar_line_sources_b rxl WHERE arapp.receivable_application_id = arl.source_id AND arl.source_table = 'RA' AND arl.customer_trx_line_id = ractrl.customer_trx_line_id AND ractrl.line_type = 'LINE' AND ractrl.interface_line_context = 'OKL_CONTRACTS' AND ractrl.interface_line_attribute14 = rxl.source_id AND rxl.source_table = 'OKL_TXD_AR_LN_DTLS_B' AND rxh.scs_code = 'INVESTOR' AND rxh.header_extension_id = rxl.header_extension_id

View Text - HTML Formatted

SELECT ARAPP.RECEIVABLE_APPLICATION_ID OKL_REC_APP_ID
, RXL.SOURCE_ID OKL_TXD_ID
, RXH.KHR_ID OKL_KHR_ID
, RXL.KLE_ID OKL_KLE_ID
, RXH.TRY_ID OKL_TRY_ID
, RXL.STY_ID TCL_STY_ID
, RXH.INV_AGRMNT_NUMBER TEH_INV_AGRMNT_NUMBER
, RXH.INV_AGRMNT_EFFECTIVE_FROM TEH_INV_AGRMNT_EFFECTIVE_FROM
, RXH.INV_AGRMNT_PRODUCT_NAME TCN_INV_AGRMNT_PRODUCT_NAME
, RXH.INV_AGRMNT_CURRENCY_CODE TEH_INV_AGRMNT_CURRENCY_CODE
, RXH.INV_AGRMNT_SYND_CODE TEH_INV_AGRMNT_SYND_CODE
, RXH.INV_AGRMNT_POOL_NUMBER TEH_INV_AGRMNT_POOL_NUMBER
, RXH.INV_AGRMNT_STATUS_CODE TEH_INV_AGRMNT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, RXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.MEMO_FLAG TEL_MEMO_FLAG
, RXL.STREAM_TYPE_CODE TCL_INV_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE TCL_INV_STREAM_TYPE_PURPOSE
FROM AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_ACTIVITY_DETAILS ARL
, RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
WHERE ARAPP.RECEIVABLE_APPLICATION_ID = ARL.SOURCE_ID
AND ARL.SOURCE_TABLE = 'RA'
AND ARL.CUSTOMER_TRX_LINE_ID = RACTRL.CUSTOMER_TRX_LINE_ID
AND RACTRL.LINE_TYPE = 'LINE'
AND RACTRL.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
AND RACTRL.INTERFACE_LINE_ATTRIBUTE14 = RXL.SOURCE_ID
AND RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
AND RXH.SCS_CODE = 'INVESTOR'
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID