APPS.POS_COMPARE_REVISIONS dependencies on PO_HEADERS_ALL

Line 502: FROM po_headers_all

498: v_progress := '100';
499:
500: SELECT clm_document_number
501: INTO v_po_num
502: FROM po_headers_all
503: WHERE po_header_id = p_header_id;
504:
505: RETURN v_po_num;
506:

Line 2208: FROM po_headers_all poh,po_lines_all pol

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

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;