[Home] [Help]
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
1528: AND sat.invoice_distribution_id = x_ref3 --bug 7428263
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
1563: AND APID.invoice_distribution_id = x_ref3 --bug 7428263
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
1596: and RCV.po_header_id = POH.po_header_id
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;
2141: /*curr_invoice_id ap_invoices.invoice_id%TYPE;*/ -- bug7428263
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;
2159: /*prev_invoice_id ap_invoices.invoice_id%TYPE;*/