DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PO_VENDORS

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 1897: curr_employee_id po_vendors.employee_id%type;

1893: description pa_project_asset_lines.description%TYPE;
1894: depreciation_expense_ccid NUMBER;
1895: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
1896:
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;

Line 1899: curr_vendor_number po_vendors.segment1%TYPE;

1895: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
1896:
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;

Line 1910: prev_employee_id po_vendors.employee_id%type;

1906: curr_payables_batch_name ap_batches.batch_name%TYPE;
1907: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
1908: curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1909: curr_inv_line_number ap_invoice_distributions.invoice_line_number%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;

Line 1912: prev_vendor_number po_vendors.segment1%TYPE;

1908: curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1909: curr_inv_line_number ap_invoice_distributions.invoice_line_number%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;