VIEW: APPS.OKL_AR_INV_IA_REF_V

Source

View Text - Preformatted

SELECT txd.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 okl_sty_id ,rxh.inv_agrmnt_number okl_inv_agrmnt_number ,rxh.inv_agrmnt_effective_from okl_inv_agrmnt_effective_from ,rxh.inv_agrmnt_product_name okl_inv_agrmnt_product_name ,rxh.inv_agrmnt_currency_code okl_inv_agrmnt_currency_code ,rxh.inv_agrmnt_synd_code okl_inv_agrmnt_synd_code ,rxh.inv_agrmnt_pool_number okl_inv_agrmnt_pool_number ,rxh.inv_agrmnt_status_code okl_inv_agrmnt_status_code ,rxh.trx_type_class_code okl_trx_type_class_code ,rxl.accounting_template_name okl_ae_template_name ,rxl.contingency_code okl_contingency_code ,rxl.memo_flag okl_memo_flag ,rxl.stream_type_code TCL_INV_STREAM_TYPE_CODE ,rxl.stream_type_purpose_code TCL_STREAM_TYPE_PURPOSE FROM OKL_EXT_AR_HEADER_SOURCES_B RXH,OKL_EXT_AR_LINE_SOURCES_B RXL,OKL_TXD_AR_LN_DTLS_B TXD WHERE rxh.scs_code = 'INVESTOR' /* As this Ref. View is only for Investor Billing*/ AND rxl.source_table = 'OKL_TXD_AR_LN_DTLS_B' AND rxh.header_extension_id = rxl.header_extension_id AND rxl.source_id = txd.id

View Text - HTML Formatted

SELECT TXD.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 OKL_STY_ID
, RXH.INV_AGRMNT_NUMBER OKL_INV_AGRMNT_NUMBER
, RXH.INV_AGRMNT_EFFECTIVE_FROM OKL_INV_AGRMNT_EFFECTIVE_FROM
, RXH.INV_AGRMNT_PRODUCT_NAME OKL_INV_AGRMNT_PRODUCT_NAME
, RXH.INV_AGRMNT_CURRENCY_CODE OKL_INV_AGRMNT_CURRENCY_CODE
, RXH.INV_AGRMNT_SYND_CODE OKL_INV_AGRMNT_SYND_CODE
, RXH.INV_AGRMNT_POOL_NUMBER OKL_INV_AGRMNT_POOL_NUMBER
, RXH.INV_AGRMNT_STATUS_CODE OKL_INV_AGRMNT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE OKL_TRX_TYPE_CLASS_CODE
, RXL.ACCOUNTING_TEMPLATE_NAME OKL_AE_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.MEMO_FLAG OKL_MEMO_FLAG
, RXL.STREAM_TYPE_CODE TCL_INV_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
, OKL_TXD_AR_LN_DTLS_B TXD
WHERE RXH.SCS_CODE = 'INVESTOR' /* AS THIS REF. VIEW IS ONLY FOR INVESTOR BILLING*/
AND RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID
AND RXL.SOURCE_ID = TXD.ID