APPS.AP_PO_AMT_MATCH_PKG dependencies on PO_LINES_ALL

Line 191: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

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

Line 192: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;

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

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

1778:
1779: --End Bug#13505998
1780:
1781: -- perf bug 5058993
1782: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1784:
1785:
1786: INSERT INTO AP_INVOICE_LINES (

Line 2160: FROM PO_LINES_ALL PL,

2156: DECODE(X_Amount,l_full_mtch_amt,G_ASSESSABLE_VALUE, NULL),
2157: G_dflt_tax_class_code,
2158: G_Pay_Awt_Group_Id --Bug 9689194
2159: -- bug 5061826 -- new FROM clause that goes to base tables
2160: FROM PO_LINES_ALL PL,
2161: PO_LINE_LOCATIONS_ALL PLL,
2162: po_distributions pd,
2163: mtl_system_items msi
2164: WHERE pll.line_location_id = x_po_line_location_id