APPS.AP_PO_AMT_MATCH_PKG dependencies on PO_LINES_ALL

Line 189: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

185:
186: --Contract Payments
187: G_Vendor_Id ap_invoices.vendor_id%TYPE;
188: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
189: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
190: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
191:
192: --Bugfix:5565310
193: G_intended_use zx_lines_det_factors.line_intended_use%type;

Line 190: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;

186: --Contract Payments
187: G_Vendor_Id ap_invoices.vendor_id%TYPE;
188: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
189: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
190: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
191:
192: --Bugfix:5565310
193: G_intended_use zx_lines_det_factors.line_intended_use%type;
194: G_product_type zx_lines_det_factors.product_type%type;

Line 1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

1662:
1663: l_debug_info := 'Inserting Item Line Matched to a PO';
1664:
1665: -- perf bug 5058993
1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1668:
1669:
1670: INSERT INTO AP_INVOICE_LINES (

Line 2041: FROM PO_LINES_ALL PL,

2037: G_USER_DEFINED_FISC_CLASS , --user_defined_fisc_clas
2038: G_ASSESSABLE_VALUE,
2039: G_dflt_tax_class_code
2040: -- bug 5061826 -- new FROM clause that goes to base tables
2041: FROM PO_LINES_ALL PL,
2042: PO_LINE_LOCATIONS_ALL PLL,
2043: po_distributions pd,
2044: mtl_system_items msi
2045: WHERE pll.line_location_id = x_po_line_location_id