APPS.POS_COMPARE_REVISIONS dependencies on PO_LINE_LOCATIONS_ALL

Line 2308: FROM po_headers_all poh,po_line_locations_all pll,po_lines_all pol

2304: ELSE
2305:
2306: SELECT segment1,poh.po_header_id,pll.shipment_num,pol.line_num
2307: INTO c_po_num,c_po_header_id,c_location_num,c_line_num
2308: FROM po_headers_all poh,po_line_locations_all pll,po_lines_all pol
2309: WHERE
2310: poh.po_header_id = pll.po_header_id and
2311: pll.line_location_id = c_entity_id and
2312: pol.po_line_id = pll.po_line_id;

Line 4730: from po_line_locations_all

4726: --get the shipment number using line location id
4727:
4728: select shipment_num
4729: into c_location_num
4730: from po_line_locations_all
4731: where line_location_id = p_dist_to.line_location_id;
4732:
4733: /*
4734: * If the old record does not exist, then this is a new one.