APPS.POS_COMPARE_REVISIONS dependencies on PO_LINE_LOCATIONS_ALL

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

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

Line 4736: from po_line_locations_all

4732: --get the shipment number using line location id
4733:
4734: select shipment_num
4735: into c_location_num
4736: from po_line_locations_all
4737: where line_location_id = p_dist_to.line_location_id;
4738:
4739: /*
4740: * If the old record does not exist, then this is a new one.