APPS.POS_COMPARE_REVISIONS dependencies on PO_HEADERS_ALL

Line 498: FROM po_headers_all

494: v_progress := '100';
495:
496: SELECT segment1
497: INTO v_po_num
498: FROM po_headers_all
499: WHERE po_header_id = p_header_id;
500:
501: RETURN v_po_num;
502:

Line 2204: FROM po_headers_all poh,po_lines_all pol

2200: if (c_entity_type = 'PO LINE' OR c_entity_type = 'BLANKET LINE') then
2201:
2202: SELECT poh.segment1,poh.po_header_id,pol.line_num
2203: INTO c_po_num,c_po_header_id,c_line_num
2204: FROM po_headers_all poh,po_lines_all pol
2205: WHERE
2206: poh.po_header_id = pol.po_header_id and
2207: pol.po_line_id = c_entity_id;
2208:

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;