DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on PO_LINES

Line 216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

212: --Contract Payments
213: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
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:
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: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
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:
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 889: FROM po_line_locations pll, po_lines pl

885: IF (x_po_line_location_id is not null) THEN
886:
887: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
888: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
889: FROM po_line_locations pll, po_lines pl
890: WHERE pll.line_location_id = x_po_line_location_id
891: AND pll.po_line_id = pl.po_line_id;
892:
893: END IF;