DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on PO_LINES

Line 218: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

214: --Contract Payments
215: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
216: G_Vendor_Id ap_invoices.vendor_id%TYPE;
217: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
218: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
219: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
220:
221: --Bugfix:5565310
222: G_intended_use zx_lines_det_factors.line_intended_use%type;

Line 219: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;

215: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
216: G_Vendor_Id ap_invoices.vendor_id%TYPE;
217: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
218: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
219: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
220:
221: --Bugfix:5565310
222: G_intended_use zx_lines_det_factors.line_intended_use%type;
223: G_product_type zx_lines_det_factors.product_type%type;

Line 982: FROM po_line_locations pll, po_lines pl

978: IF (x_po_line_location_id is not null) THEN
979:
980: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
981: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
982: FROM po_line_locations pll, po_lines pl
983: WHERE pll.line_location_id = x_po_line_location_id
984: AND pll.po_line_id = pl.po_line_id;
985:
986: END IF;