APPS.PA_FAXFACE dependencies on PO_HEADERS

Line 1413: po_vendors POV, po_headers POH ,po_distributions POD

1409: x_invoice_date, x_invoice_created_by,
1410: x_invoice_updated_by,
1411: x_payables_batch_name
1412: from ap_invoices API, ap_invoice_distributions APID, ap_batches APB,
1413: po_vendors POV, po_headers POH ,po_distributions POD
1414: where API.invoice_id = x_invoice_id
1415: and APID.invoice_distribution_id = x_ap_inv_dist_id
1416: and APID.invoice_id = API.invoice_id
1417: and APID.po_distribution_id = POD.po_distribution_id(+)

Line 1901: curr_po_number po_headers.segment1%TYPE;

1897: curr_employee_id po_vendors.employee_id%type;
1898: curr_invoice_num ap_invoices.invoice_num%TYPE;
1899: curr_vendor_number po_vendors.segment1%TYPE;
1900: curr_po_vendor_id ap_invoices.vendor_id%TYPE;
1901: curr_po_number po_headers.segment1%TYPE;
1902: curr_invoice_date ap_invoices.invoice_date%TYPE;
1903: curr_invoice_created_by ap_invoices.created_by%TYPE;
1904: curr_invoice_updated_by ap_invoices.last_updated_by%TYPE;
1905: curr_invoice_id ap_invoices.invoice_id%TYPE;

Line 1914: prev_po_number po_headers.segment1%TYPE;

1910: prev_employee_id po_vendors.employee_id%type;
1911: prev_invoice_num ap_invoices.invoice_num%TYPE;
1912: prev_vendor_number po_vendors.segment1%TYPE;
1913: prev_po_vendor_id ap_invoices.vendor_id%TYPE;
1914: prev_po_number po_headers.segment1%TYPE;
1915: prev_invoice_date ap_invoices.invoice_date%TYPE;
1916: prev_invoice_created_by ap_invoices.created_by%TYPE;
1917: prev_invoice_updated_by ap_invoices.last_updated_by%TYPE;
1918: prev_invoice_id ap_invoices.invoice_id%TYPE;