VIEW: APPS.OKL_AP_PAYMENTS_REF_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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