View: OKL_AP_PAYMENTS_REF_VL

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

View Text

SELECT AID.INVOICE_DISTRIBUTION_ID OKL_INVOICE_DISTRIBUTION_ID
, PXH.KHR_ID OKL_KHR_ID
, PXHL.LANGUAGE LANGUAGE
, PXHL.CONTRACT_STATUS TEHL_CONTRACT_STATUS
, DECODE(PXH.SCS_CODE
, 'LEASE'
, PXLL.INVENTORY_ORG_NAME
, NULL ) TELL_INVENTORY_ORG_NAME
, PXHL.TRANSACTION_TYPE_NAME TEHL_TRANSACTION_TYPE_NAME
, PXLL.INVENTORY_ITEM_NAME TELL_INVENTORY_ITEM_NAME
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_LINE_SOURCES_B PXL
, OKL_EXT_AP_HEADER_SOURCES_TL PXHL
, OKL_EXT_AP_LINE_SOURCES_TL PXLL
, AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_INVOICE_LINES_ALL AIL
, OKL_TXL_AP_INV_LNS_ALL_B TAL
WHERE 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
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 PXH.HEADER_EXTENSION_ID = PXHL.HEADER_EXTENSION_ID
AND PXL.LINE_EXTENSION_ID = PXLL.LINE_EXTENSION_ID
AND PXHL.LANGUAGE = PXLL.LANGUAGE

Columns