AP_DOCUMENT_LINES

Details

Schema: FUSION
Object owner: AP
Object type: VIEW

Columns

Name
CALLING_APP_ID CALL_APP_PAY_SERVICE_REQ_CODE CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF5 PO_NUMBER LINE_NUMBER LINE_TYPE LINE_GROSS_AMOUNT DESCRIPTION UNIT_PRICE QUANTITY UNIT_OF_MEASURE TAX TAX_RATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15

Name

CALLING_APP_ID

CALL_APP_PAY_SERVICE_REQ_CODE

CALLING_APP_DOC_UNIQUE_REF1

CALLING_APP_DOC_UNIQUE_REF2

CALLING_APP_DOC_UNIQUE_REF3

CALLING_APP_DOC_UNIQUE_REF4

CALLING_APP_DOC_UNIQUE_REF5

PO_NUMBER

LINE_NUMBER

LINE_TYPE

LINE_GROSS_AMOUNT

DESCRIPTION

UNIT_PRICE

QUANTITY

UNIT_OF_MEASURE

TAX

TAX_RATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

Query

SQL_Statement
SELECT 200, decode(ac.checkrun_name, null, to_char(ac.check_id), ac.checkrun_name) , ac.check_id calling_app_doc_unique_ref1, aps.invoice_id calling_app_doc_unique_ref2, aps.payment_num calling_app_doc_unique_ref3, aip.invoice_payment_id calling_app_doc_unique_ref4, NULL calling_app_doc_unique_ref5, ph.segment1 po_number, ail.line_number, ail.line_type_lookup_code line_type, ail.amount line_gross_amount, ail.description, ail.unit_price, ail.quantity_invoiced quantity, ail.unit_meas_lookup_code unit_of_measure, 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(+)

SQL_Statement

SELECT 200, decode(ac.checkrun_name, null, to_char(ac.check_id), ac.checkrun_name) , ac.check_id calling_app_doc_unique_ref1, aps.invoice_id calling_app_doc_unique_ref2, aps.payment_num calling_app_doc_unique_ref3, aip.invoice_payment_id calling_app_doc_unique_ref4, NULL calling_app_doc_unique_ref5, ph.segment1 po_number, ail.line_number, ail.line_type_lookup_code line_type, ail.amount line_gross_amount, ail.description, ail.unit_price, ail.quantity_invoiced quantity, ail.unit_meas_lookup_code unit_of_measure, 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(+)