Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AP_REF_VL |
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