APPS.AP_MATCHING_PKG dependencies on PO_LINES_ALL

Line 216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;
219: --Bugfix:5565310
220: G_intended_use zx_lines_det_factors.line_intended_use%type;

Line 217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;

213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;
219: --Bugfix:5565310
220: G_intended_use zx_lines_det_factors.line_intended_use%type;
221: G_product_type zx_lines_det_factors.product_type%type;

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

1826: END IF;
1827: --End Bug#13505998
1828:
1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,

Line 2205: FROM PO_LINES_ALL PL,

2201: DECODE(X_Amount,l_full_mtch_amt,G_ASSESSABLE_VALUE, NULL),
2202: G_dflt_tax_class_code,
2203: G_PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2204: -- bug 5061826 -- new FROM clause that goes to base tables
2205: FROM PO_LINES_ALL PL,
2206: PO_LINE_LOCATIONS_ALL PLL,
2207: po_distributions pd,
2208: mtl_system_items msi
2209: WHERE pll.line_location_id = x_po_line_location_id