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_INVOICE_DISTRIBUTIONS

Line 175: ap_invoice_distributions_all apid,

171: mtlsi.asset_category_id
172: INTO
173: asset_category_id
174: FROM
175: ap_invoice_distributions_all apid,
176: po_distributions pod,
177: po_lines pol,
178: financials_system_parameters fsp,
179: mtl_system_items mtlsi

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 1907: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%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;
1910: prev_employee_id po_vendors.employee_id%type;
1911: prev_invoice_num ap_invoices.invoice_num%TYPE;

Line 1908: curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%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;
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;

Line 1909: curr_inv_line_number ap_invoice_distributions.invoice_line_number%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;
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;

Line 1920: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%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;
1923:
1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;

Line 1921: prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%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;
1923:
1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;

Line 1922: prev_inv_line_number ap_invoice_distributions.invoice_line_number%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;
1923:
1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;