eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FAXFACE dependencies on AP_INVOICES

Line 1412: from ap_invoices API, ap_invoice_distributions APID, ap_batches APB,

1408: x_po_vendor_id, x_po_number,
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

Line 1898: curr_invoice_num ap_invoices.invoice_num%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;
1902: curr_invoice_date ap_invoices.invoice_date%TYPE;

Line 1900: curr_po_vendor_id ap_invoices.vendor_id%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;
1904: curr_invoice_updated_by ap_invoices.last_updated_by%TYPE;

Line 1902: curr_invoice_date ap_invoices.invoice_date%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;
1906: curr_payables_batch_name ap_batches.batch_name%TYPE;

Line 1903: curr_invoice_created_by ap_invoices.created_by%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;
1906: curr_payables_batch_name ap_batches.batch_name%TYPE;
1907: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;

Line 1904: curr_invoice_updated_by ap_invoices.last_updated_by%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;
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;

Line 1905: curr_invoice_id ap_invoices.invoice_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;
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;

Line 1911: prev_invoice_num ap_invoices.invoice_num%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;
1915: prev_invoice_date ap_invoices.invoice_date%TYPE;

Line 1913: prev_po_vendor_id ap_invoices.vendor_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;
1917: prev_invoice_updated_by ap_invoices.last_updated_by%TYPE;

Line 1915: prev_invoice_date ap_invoices.invoice_date%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;
1919: prev_payables_batch_name ap_batches.batch_name%TYPE;

Line 1916: prev_invoice_created_by ap_invoices.created_by%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;
1919: prev_payables_batch_name ap_batches.batch_name%TYPE;
1920: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;

Line 1917: prev_invoice_updated_by ap_invoices.last_updated_by%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;
1919: prev_payables_batch_name ap_batches.batch_name%TYPE;
1920: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
1921: prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 1918: prev_invoice_id ap_invoices.invoice_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;
1919: prev_payables_batch_name ap_batches.batch_name%TYPE;
1920: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
1921: prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1922: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;