DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 597: DELETE FROM po_line_locations_all_ext_b

593: FROM po_lines_draft_all
594: WHERE po_header_id = p_entity_id
595: AND draft_id = p_draft_id));
596:
597: DELETE FROM po_line_locations_all_ext_b
598: WHERE draft_id = p_draft_id
599: AND line_location_id IN(SELECT line_location_id
600: FROM po_line_locations_draft_all
601: WHERE po_header_id = p_entity_id

Line 623: DELETE FROM po_line_locations_all_ext_b

619: OR ( draft_id = -1 -- old record for complex pricing
620: AND po_line_id = p_entity_id
621: AND pk1_value = p_draft_id);
622:
623: DELETE FROM po_line_locations_all_ext_b
624: WHERE draft_id = p_draft_id
625: AND line_location_id IN (SELECT line_location_id
626: FROM po_line_locations_draft_all
627: WHERE po_line_id = p_entity_id

Line 649: DELETE FROM po_line_locations_all_ext_b

645: AND draft_id = p_draft_id);
646:
647: ELSIF p_entity_level = 'PO_SHIPMENT' THEN
648:
649: DELETE FROM po_line_locations_all_ext_b
650: WHERE draft_id = p_draft_id
651: AND line_location_id = p_entity_id;
652:
653: DELETE FROM po_line_locations_all_ext_tl