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 199: ap_invoice_distributions_all apid,

195: mtlsi.asset_category_id
196: INTO
197: asset_category_id
198: FROM
199: ap_invoice_distributions_all apid,
200: po_distributions pod,
201: po_lines pol,
202: financials_system_parameters fsp,
203: mtl_system_items mtlsi

Line 676: from ap_invoice_distributions_all

672: BEGIN
673:
674: select DISTRIBUTION_LINE_NUMBER, INVOICE_LINE_NUMBER
675: into l_ap_distribution_line_number, l_invoice_line_number
676: from ap_invoice_distributions_all
677: where INVOICE_ID = x_invoice_id
678: and INVOICE_DISTRIBUTION_ID = x_invoice_distribution_id;
679:
680: EXCEPTION

Line 1556: ap_invoice_distributions_all APID,

1552: x_invoice_created_by,
1553: x_invoice_updated_by,
1554: x_payables_batch_name
1555: FROM ap_invoices_all API ,
1556: ap_invoice_distributions_all APID,
1557: ap_batches_all APB ,
1558: po_vendors POV ,
1559: po_headers_all POH ,
1560: po_distributions_all POD

Line 2145: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;

2141: /*curr_invoice_id ap_invoices.invoice_id%TYPE;*/ -- bug7428263
2142: curr_ref2 pa_expenditure_items.document_header_id%TYPE; -- bug7428263
2143: curr_transaction_source pa_expenditure_items.transaction_source%TYPE; -- bug7428263
2144: curr_payables_batch_name ap_batches.batch_name%TYPE;
2145: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
2146: curr_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2147: curr_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2148: curr_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2149: /*curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;*/ -- bug7428263

Line 2148: curr_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806

2144: curr_payables_batch_name ap_batches.batch_name%TYPE;
2145: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
2146: curr_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2147: curr_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2148: curr_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2149: /*curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;*/ -- bug7428263
2150: curr_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2151: prev_employee_id po_vendors.employee_id%type;
2152: prev_invoice_num ap_invoices.invoice_num%TYPE;

Line 2149: /curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;/ -- bug7428263

2145: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
2146: curr_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2147: curr_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2148: curr_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2149: /*curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;*/ -- bug7428263
2150: curr_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2151: prev_employee_id po_vendors.employee_id%type;
2152: prev_invoice_num ap_invoices.invoice_num%TYPE;
2153: prev_vendor_number po_vendors.segment1%TYPE;

Line 2150: curr_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;

2146: curr_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2147: curr_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2148: curr_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2149: /*curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;*/ -- bug7428263
2150: curr_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2151: prev_employee_id po_vendors.employee_id%type;
2152: prev_invoice_num ap_invoices.invoice_num%TYPE;
2153: prev_vendor_number po_vendors.segment1%TYPE;
2154: prev_po_vendor_id ap_invoices.vendor_id%TYPE;

Line 2162: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;

2158: prev_invoice_updated_by ap_invoices.last_updated_by%TYPE;
2159: /*prev_invoice_id ap_invoices.invoice_id%TYPE;*/
2160: prev_ref2 ap_invoices.invoice_id%TYPE;
2161: prev_payables_batch_name ap_batches.batch_name%TYPE;
2162: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
2163: prev_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2164: prev_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2165: prev_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263

Line 2165: prev_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806

2161: prev_payables_batch_name ap_batches.batch_name%TYPE;
2162: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
2163: prev_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2164: prev_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2165: prev_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263
2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2168:
2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;

Line 2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263

2162: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
2163: prev_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2164: prev_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2165: prev_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263
2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2168:
2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;

Line 2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;

2163: prev_ref3 pa_expenditure_items.document_distribution_id%TYPE;-- bug7428263
2164: prev_ref4 pa_expenditure_items.document_line_number%TYPE;-- bug7428263
2165: prev_inv_pod ap_invoice_distributions.po_distribution_id%TYPE; -- bug10429806
2166: --prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE; -- bug7428263
2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2168:
2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;

Line 2297: FROM ap_invoice_distributions_all apd

2293: else
2294:
2295: SELECT NVL(apd.po_distribution_id,-99)
2296: INTO curr_inv_pod
2297: FROM ap_invoice_distributions_all apd
2298: WHERE apd.invoice_distribution_id = cdlrec.document_distribution_id;
2299:
2300: end if;
2301:

Line 3306: from ap_invoice_distributions_all

3302: BEGIN
3303:
3304: select DISTRIBUTION_LINE_NUMBER, INVOICE_LINE_NUMBER
3305: into l_ap_distribution_line_number, l_invoice_line_number
3306: from ap_invoice_distributions_all
3307: where INVOICE_ID = x_invoice_id
3308: and INVOICE_DISTRIBUTION_ID = x_invoice_distribution_id;
3309:
3310: EXCEPTION