VIEW: APPS.OKL_TRX_LINE_UV

Source

View Text - Preformatted

SELECT OTCL.ID ID, OTCL.LINE_NUMBER LINE_NUMBER, OTCL.DESCRIPTION DESCRIPTION, OTCL.AMOUNT AMOUNT, OTCL.CURRENCY_CODE CURRENCY_CODE, OST.NAME STREAM_TYPE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE', OST.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE, OTCL.TCN_ID TRANSACTION_ID, 'OKL_TXL_CNTRCT_LNS' SOURCE_TABLE, OTCL.KHR_ID KHR_ID FROM OKL_TXL_CNTRCT_LNS OTCL,OKL_STRM_TYPE_V OST WHERE OTCL.STY_ID = OST.ID(+) UNION ALL SELECT ASL.ID ID, ASL.LINE_NUMBER LINE_NUMBER, ASL.MANUFACTURER_NAME DESCRIPTION, ASL.MATCH_AMOUNT AMOUNT, ASL.CURRENCY_CODE CURRENCY_CODE, NULL STREAM_TYPE, NULL STREAM_TYPE_PURPOSE, ASL.TAS_ID TRANSACTION_ID, 'OKL_TXL_ASSETS_B' SOURCE_TABLE, ASL.DNZ_KHR_ID KHR_ID FROM OKL_TXL_ASSETS_B ASL

View Text - HTML Formatted

SELECT OTCL.ID ID
, OTCL.LINE_NUMBER LINE_NUMBER
, OTCL.DESCRIPTION DESCRIPTION
, OTCL.AMOUNT AMOUNT
, OTCL.CURRENCY_CODE CURRENCY_CODE
, OST.NAME STREAM_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, OST.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
, OTCL.TCN_ID TRANSACTION_ID
, 'OKL_TXL_CNTRCT_LNS' SOURCE_TABLE
, OTCL.KHR_ID KHR_ID
FROM OKL_TXL_CNTRCT_LNS OTCL
, OKL_STRM_TYPE_V OST
WHERE OTCL.STY_ID = OST.ID(+) UNION ALL SELECT ASL.ID ID
, ASL.LINE_NUMBER LINE_NUMBER
, ASL.MANUFACTURER_NAME DESCRIPTION
, ASL.MATCH_AMOUNT AMOUNT
, ASL.CURRENCY_CODE CURRENCY_CODE
, NULL STREAM_TYPE
, NULL STREAM_TYPE_PURPOSE
, ASL.TAS_ID TRANSACTION_ID
, 'OKL_TXL_ASSETS_B' SOURCE_TABLE
, ASL.DNZ_KHR_ID KHR_ID
FROM OKL_TXL_ASSETS_B ASL