DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PO_VENDORS

Line 1523: po_vendors POV ,

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 ,
1525: po_distributions_all POD
1526: /* Added _all for bug 9253946 */
1527: WHERE API.invoice_id = x_ref2

Line 1558: po_vendors POV ,

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
1561: /* Added _all for bug 9253946 */
1562: WHERE API.invoice_id = x_ref2

Line 1591: po_vendors POV,

1587: x_invoice_updated_by,
1588: x_payables_batch_name
1589: from rcv_shipment_headers RCH,
1590: rcv_transactions RCV,
1591: po_vendors POV,
1592: po_headers_all POH /* Added _all for bug 9253946 */
1593: where RCV.po_header_id = x_ref2
1594: and RCV.po_distribution_id = x_ref4
1595: and RCV.transaction_id = x_ref3

Line 2133: curr_employee_id po_vendors.employee_id%type;

2129: description pa_project_asset_lines.description%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;

Line 2135: curr_vendor_number po_vendors.segment1%TYPE;

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;
2139: curr_invoice_created_by ap_invoices.created_by%TYPE;

Line 2151: prev_employee_id po_vendors.employee_id%type;

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

Line 2153: prev_vendor_number po_vendors.segment1%TYPE;

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