View: OKL_AP_PAYMENTS_IA_REF_V

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AP_PAYMENTS_IA_REF_V

View Text

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

Columns