View: AP_DOCUMENT_LINES_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_DOCUMENT_LINES_V

View Text

SELECT 200
, TO_CHAR(AC.CHECK_ID)
, AC.CHECK_ID
, APS.INVOICE_ID
, APS.PAYMENT_NUM
, AIP.INVOICE_PAYMENT_ID
, NULL
, PH.SEGMENT1
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE
, AIL.AMOUNT
, AIL.DESCRIPTION
, AIL.UNIT_PRICE
, AIL.QUANTITY_INVOICED
, AIL.UNIT_MEAS_LOOKUP_CODE
, AIL.TAX
, AIL.TAX_RATE
, AIL.CREATED_BY
, AIL.CREATION_DATE
, AIL.LAST_UPDATED_BY
, AIL.LAST_UPDATE_DATE
, AIL.LAST_UPDATE_LOGIN
, AIL.ATTRIBUTE_CATEGORY
, AIL.ATTRIBUTE1
, AIL.ATTRIBUTE2
, AIL.ATTRIBUTE3
, AIL.ATTRIBUTE4
, AIL.ATTRIBUTE5
, AIL.ATTRIBUTE6
, AIL.ATTRIBUTE7
, AIL.ATTRIBUTE8
, AIL.ATTRIBUTE9
, AIL.ATTRIBUTE10
, AIL.ATTRIBUTE11
, AIL.ATTRIBUTE12
, AIL.ATTRIBUTE13
, AIL.ATTRIBUTE14
, AIL.ATTRIBUTE15
FROM AP_CHECKS_ALL AC
, AP_INVOICES_ALL AI
, AP_INVOICE_PAYMENTS_ALL AIP
, AP_PAYMENT_SCHEDULES_ALL APS
, AP_INVOICE_LINES_ALL AIL
, PO_HEADERS_ALL PH
WHERE AC.CHECK_ID = AIP.CHECK_ID
AND AIP.INVOICE_ID = AI.INVOICE_ID
AND AI.INVOICE_ID = APS.INVOICE_ID
AND APS.PAYMENT_NUM = AIP.PAYMENT_NUM
AND AI.INVOICE_ID = AIL.INVOICE_ID
AND AI.ORG_ID = AC.ORG_ID
AND AI.ORG_ID = AIL.ORG_ID
AND AIL.PO_HEADER_ID = PH.PO_HEADER_ID(+) UNION SELECT 200
, AISC.CHECKRUN_NAME
, AISC.CHECKRUN_ID
, ASI.INVOICE_ID
, ASI.PAYMENT_NUM
, NULL
, NULL
, PH.SEGMENT1
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE
, AIL.AMOUNT
, AIL.DESCRIPTION
, AIL.UNIT_PRICE
, AIL.QUANTITY_INVOICED
, AIL.UNIT_MEAS_LOOKUP_CODE
, AIL.TAX
, AIL.TAX_RATE
, AIL.CREATED_BY
, AIL.CREATION_DATE
, AIL.LAST_UPDATED_BY
, AIL.LAST_UPDATE_DATE
, AIL.LAST_UPDATE_LOGIN
, AIL.ATTRIBUTE_CATEGORY
, AIL.ATTRIBUTE1
, AIL.ATTRIBUTE2
, AIL.ATTRIBUTE3
, AIL.ATTRIBUTE4
, AIL.ATTRIBUTE5
, AIL.ATTRIBUTE6
, AIL.ATTRIBUTE7
, AIL.ATTRIBUTE8
, AIL.ATTRIBUTE9
, AIL.ATTRIBUTE10
, AIL.ATTRIBUTE11
, AIL.ATTRIBUTE12
, AIL.ATTRIBUTE13
, AIL.ATTRIBUTE14
, AIL.ATTRIBUTE15
FROM AP_INVOICES_ALL AI
, AP_SELECTED_INVOICES_ALL ASI
, AP_INV_SELECTION_CRITERIA_ALL AISC
, AP_PAYMENT_SCHEDULES_ALL APS
, AP_INVOICE_LINES_ALL AIL
, PO_HEADERS_ALL PH
WHERE AI.INVOICE_ID = ASI.INVOICE_ID
AND ASI.CHECKRUN_NAME = AISC.CHECKRUN_NAME
AND APS.INVOICE_ID = ASI.INVOICE_ID
AND APS.PAYMENT_NUM = ASI.PAYMENT_NUM
AND AIL.ORG_ID = AI.ORG_ID
AND AI.INVOICE_ID = AIL.INVOICE_ID
AND AIL.PO_HEADER_ID = PH.PO_HEADER_ID(+) UNION SELECT 200
, AISC.CHECKRUN_NAME
, AISC.CHECKRUN_ID
, ASI2.INVOICE_ID
, ASI2.PAYMENT_NUM
, NULL
, NULL
, PH.SEGMENT1
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE
, AIL.AMOUNT
, AIL.DESCRIPTION
, AIL.UNIT_PRICE
, AIL.QUANTITY_INVOICED
, AIL.UNIT_MEAS_LOOKUP_CODE
, AIL.TAX
, AIL.TAX_RATE
, AIL.CREATED_BY
, AIL.CREATION_DATE
, AIL.LAST_UPDATED_BY
, AIL.LAST_UPDATE_DATE
, AIL.LAST_UPDATE_LOGIN
, AIL.ATTRIBUTE_CATEGORY
, AIL.ATTRIBUTE1
, AIL.ATTRIBUTE2
, AIL.ATTRIBUTE3
, AIL.ATTRIBUTE4
, AIL.ATTRIBUTE5
, AIL.ATTRIBUTE6
, AIL.ATTRIBUTE7
, AIL.ATTRIBUTE8
, AIL.ATTRIBUTE9
, AIL.ATTRIBUTE10
, AIL.ATTRIBUTE11
, AIL.ATTRIBUTE12
, AIL.ATTRIBUTE13
, AIL.ATTRIBUTE14
, AIL.ATTRIBUTE15
FROM AP_INVOICES_ALL AI
, AP_SELECTED_INVOICES_ALL ASI
, AP_INV_SELECTION_CRITERIA_ALL AISC
, AP_PAYMENT_SCHEDULES_ALL APS
, AP_SELECTED_INVOICES_ALL ASI2
, AP_INVOICE_LINES_ALL AIL
, PO_HEADERS_ALL PH
WHERE AI.INVOICE_ID = ASI.INVOICE_ID
AND ASI.CHECKRUN_NAME = AISC.CHECKRUN_NAME
AND APS.INVOICE_ID = ASI.INVOICE_ID
AND APS.PAYMENT_NUM = ASI.PAYMENT_NUM
AND ASI2.ORIGINAL_INVOICE_ID = ASI.INVOICE_ID
AND ASI2.PAYMENT_NUM = ASI.PAYMENT_NUM
AND ASI2.INVOICE_ID = AIL.INVOICE_ID
AND ASI2.ORG_ID = AIL.ORG_ID
AND AIL.PO_HEADER_ID = PH.PO_HEADER_ID(+)

Columns