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 1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

1727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,

Line 2105: FROM PO_LINES_ALL PL,

2101: G_ASSESSABLE_VALUE,
2102: G_dflt_tax_class_code,
2103: G_PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2104: -- bug 5061826 -- new FROM clause that goes to base tables
2105: FROM PO_LINES_ALL PL,
2106: PO_LINE_LOCATIONS_ALL PLL,
2107: po_distributions pd,
2108: mtl_system_items msi
2109: WHERE pll.line_location_id = x_po_line_location_id