DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on AP_INVOICES

Line 1520: FROM ap_invoices_all API ,

1516: x_invoice_date ,
1517: x_invoice_created_by,
1518: x_invoice_updated_by,
1519: x_payables_batch_name
1520: FROM ap_invoices_all API ,
1521: ap_self_assessed_tax_dist_all sat,
1522: ap_batches_all APB ,
1523: po_vendors POV ,
1524: po_headers_all POH ,

Line 1555: FROM ap_invoices_all API ,

1551: x_invoice_date ,
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 ,

Line 2134: curr_invoice_num ap_invoices.invoice_num%TYPE;

2130: depreciation_expense_ccid NUMBER;
2131: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
2132:
2133: curr_employee_id po_vendors.employee_id%type;
2134: curr_invoice_num ap_invoices.invoice_num%TYPE;
2135: curr_vendor_number po_vendors.segment1%TYPE;
2136: curr_po_vendor_id ap_invoices.vendor_id%TYPE;
2137: curr_po_number po_headers.segment1%TYPE;
2138: curr_invoice_date ap_invoices.invoice_date%TYPE;

Line 2136: curr_po_vendor_id ap_invoices.vendor_id%TYPE;

2132:
2133: curr_employee_id po_vendors.employee_id%type;
2134: curr_invoice_num ap_invoices.invoice_num%TYPE;
2135: curr_vendor_number po_vendors.segment1%TYPE;
2136: curr_po_vendor_id ap_invoices.vendor_id%TYPE;
2137: curr_po_number po_headers.segment1%TYPE;
2138: curr_invoice_date ap_invoices.invoice_date%TYPE;
2139: curr_invoice_created_by ap_invoices.created_by%TYPE;
2140: curr_invoice_updated_by ap_invoices.last_updated_by%TYPE;

Line 2138: curr_invoice_date ap_invoices.invoice_date%TYPE;

2134: curr_invoice_num ap_invoices.invoice_num%TYPE;
2135: curr_vendor_number po_vendors.segment1%TYPE;
2136: curr_po_vendor_id ap_invoices.vendor_id%TYPE;
2137: curr_po_number po_headers.segment1%TYPE;
2138: curr_invoice_date ap_invoices.invoice_date%TYPE;
2139: curr_invoice_created_by ap_invoices.created_by%TYPE;
2140: curr_invoice_updated_by ap_invoices.last_updated_by%TYPE;
2141: /*curr_invoice_id ap_invoices.invoice_id%TYPE;*/ -- bug7428263
2142: curr_ref2 pa_expenditure_items.document_header_id%TYPE; -- bug7428263

Line 2139: curr_invoice_created_by ap_invoices.created_by%TYPE;

2135: curr_vendor_number po_vendors.segment1%TYPE;
2136: curr_po_vendor_id ap_invoices.vendor_id%TYPE;
2137: curr_po_number po_headers.segment1%TYPE;
2138: curr_invoice_date ap_invoices.invoice_date%TYPE;
2139: curr_invoice_created_by ap_invoices.created_by%TYPE;
2140: curr_invoice_updated_by ap_invoices.last_updated_by%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

Line 2140: curr_invoice_updated_by ap_invoices.last_updated_by%TYPE;

2136: curr_po_vendor_id ap_invoices.vendor_id%TYPE;
2137: curr_po_number po_headers.segment1%TYPE;
2138: curr_invoice_date ap_invoices.invoice_date%TYPE;
2139: curr_invoice_created_by ap_invoices.created_by%TYPE;
2140: curr_invoice_updated_by ap_invoices.last_updated_by%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;

Line 2141: /*curr_invoice_id ap_invoices.invoice_id%TYPE;*/ -- bug7428263

2137: curr_po_number po_headers.segment1%TYPE;
2138: curr_invoice_date ap_invoices.invoice_date%TYPE;
2139: curr_invoice_created_by ap_invoices.created_by%TYPE;
2140: curr_invoice_updated_by ap_invoices.last_updated_by%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;

Line 2152: prev_invoice_num ap_invoices.invoice_num%TYPE;

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;
2155: prev_po_number po_headers.segment1%TYPE;
2156: prev_invoice_date ap_invoices.invoice_date%TYPE;

Line 2154: prev_po_vendor_id ap_invoices.vendor_id%TYPE;

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;
2155: prev_po_number po_headers.segment1%TYPE;
2156: prev_invoice_date ap_invoices.invoice_date%TYPE;
2157: prev_invoice_created_by ap_invoices.created_by%TYPE;
2158: prev_invoice_updated_by ap_invoices.last_updated_by%TYPE;

Line 2156: prev_invoice_date ap_invoices.invoice_date%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;
2155: prev_po_number po_headers.segment1%TYPE;
2156: prev_invoice_date ap_invoices.invoice_date%TYPE;
2157: prev_invoice_created_by ap_invoices.created_by%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;

Line 2157: prev_invoice_created_by ap_invoices.created_by%TYPE;

2153: prev_vendor_number po_vendors.segment1%TYPE;
2154: prev_po_vendor_id ap_invoices.vendor_id%TYPE;
2155: prev_po_number po_headers.segment1%TYPE;
2156: prev_invoice_date ap_invoices.invoice_date%TYPE;
2157: prev_invoice_created_by ap_invoices.created_by%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;

Line 2158: prev_invoice_updated_by ap_invoices.last_updated_by%TYPE;

2154: prev_po_vendor_id ap_invoices.vendor_id%TYPE;
2155: prev_po_number po_headers.segment1%TYPE;
2156: prev_invoice_date ap_invoices.invoice_date%TYPE;
2157: prev_invoice_created_by ap_invoices.created_by%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;

Line 2159: /*prev_invoice_id ap_invoices.invoice_id%TYPE;*/

2155: prev_po_number po_headers.segment1%TYPE;
2156: prev_invoice_date ap_invoices.invoice_date%TYPE;
2157: prev_invoice_created_by ap_invoices.created_by%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

Line 2160: prev_ref2 ap_invoices.invoice_id%TYPE;

2156: prev_invoice_date ap_invoices.invoice_date%TYPE;
2157: prev_invoice_created_by ap_invoices.created_by%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