APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_LINE_LOCATIONS

Line 154: po_line_locations pll

150: -- bug 3903136 select the po uom and item id
151: SELECT pol.unit_meas_lookup_code, pol.item_id
152: INTO l_po_uom, l_item_id
153: FROM po_lines pol,
154: po_line_locations pll
155: WHERE pol.po_line_id = pll.po_line_id
156: AND pll.line_location_id = p_po_line_location_id;
157:
158: LOOP

Line 1228: l_matching_basis PO_LINE_LOCATIONS_ALL.MATCHING_BASIS%TYPE;

1224: P_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
1225:
1226: current_calling_sequence VARCHAR2(2000);
1227: debug_info VARCHAR2(500);
1228: l_matching_basis PO_LINE_LOCATIONS_ALL.MATCHING_BASIS%TYPE;
1229:
1230: BEGIN
1231: -- Update the calling sequence
1232:

Line 1279: po_line_locations pll

1275: p_amount_ordered,
1276: p_amt_already_billed,
1277: l_matching_basis
1278: FROM po_distributions_ap_v pod,
1279: po_line_locations pll
1280: WHERE pod.line_location_id = p_po_shipment_id
1281: AND pll.line_location_id = pod.line_location_id
1282: GROUP BY pod.distribution_type,pll.matching_basis ;
1283:

Line 2337: FROM po_line_locations pll,

2333: INTO p_outstanding,
2334: p_ordered,
2335: p_already_billed,
2336: p_po_line_matching_basis
2337: FROM po_line_locations pll,
2338: po_lines pl
2339: WHERE pll.po_line_id = p_po_line_id
2340: AND pl.po_line_id = pll.po_line_id
2341: -- bug fix 6959362 starts