VIEW: APPS.AP_DOCUMENT_LINES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)