VIEW: APPS.OKL_AP_REF_VL

Source

View Text - Preformatted

SELECT pxl.source_id OKL_TPL_ID ,pxhl.language LANGUAGE ,'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE ,pxhl.contract_status TEHL_CONTRACT_STATUS ,pxhl.transaction_type_name TEHL_TRANSACTION_TYPE_NAME ,DECODE(pxh.scs_code, 'LEASE', pxll.inventory_org_name, NULL ) TELL_INVENTORY_ORG_NAME ,pxll.stream_type_name STM_STREAM_TYPE_NAME ,pxll.trans_line_description TCL_DESCRIPTION_TRANS ,pxhl.inv_agrmnt_status TEHL_INV_AGRMNT_STATUS ,pxll.inventory_item_name TELL_INVENTORY_ITEM_NAME FROM OKL_EXT_AP_HEADER_SOURCES_B PXH,OKL_EXT_AP_HEADER_SOURCES_TL PXHL,OKL_EXT_AP_LINE_SOURCES_B PXL,OKL_EXT_AP_LINE_SOURCES_TL PXLL WHERE pxl.source_table = 'OKL_TXL_AP_INV_LNS_B' AND pxl.line_extension_id = pxll.line_extension_id AND pxl.header_extension_id = pxh.header_extension_id AND pxh.header_extension_id = pxhl.header_extension_id AND pxhl.language = pxll.language

View Text - HTML Formatted

SELECT PXL.SOURCE_ID OKL_TPL_ID
, PXHL.LANGUAGE LANGUAGE
, 'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE
, PXHL.CONTRACT_STATUS TEHL_CONTRACT_STATUS
, PXHL.TRANSACTION_TYPE_NAME TEHL_TRANSACTION_TYPE_NAME
, DECODE(PXH.SCS_CODE
, 'LEASE'
, PXLL.INVENTORY_ORG_NAME
, NULL ) TELL_INVENTORY_ORG_NAME
, PXLL.STREAM_TYPE_NAME STM_STREAM_TYPE_NAME
, PXLL.TRANS_LINE_DESCRIPTION TCL_DESCRIPTION_TRANS
, PXHL.INV_AGRMNT_STATUS TEHL_INV_AGRMNT_STATUS
, PXLL.INVENTORY_ITEM_NAME TELL_INVENTORY_ITEM_NAME
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_HEADER_SOURCES_TL PXHL
, OKL_EXT_AP_LINE_SOURCES_B PXL
, OKL_EXT_AP_LINE_SOURCES_TL PXLL
WHERE PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B'
AND PXL.LINE_EXTENSION_ID = PXLL.LINE_EXTENSION_ID
AND PXL.HEADER_EXTENSION_ID = PXH.HEADER_EXTENSION_ID
AND PXH.HEADER_EXTENSION_ID = PXHL.HEADER_EXTENSION_ID
AND PXHL.LANGUAGE = PXLL.LANGUAGE