DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_LINES_ALL_EXT_B

Line 559: DELETE FROM po_lines_all_ext_b

555: DELETE FROM po_headers_all_ext_tl
556: WHERE draft_id = p_draft_id
557: AND po_header_id = p_entity_id;
558:
559: DELETE FROM po_lines_all_ext_b
560: WHERE (draft_id = p_draft_id --main record for Mod
561: AND po_line_id IN (SELECT po_line_id
562: FROM po_lines_draft_all
563: WHERE po_header_id = p_entity_id

Line 613: DELETE FROM po_lines_all_ext_b

609: AND draft_id = p_draft_id);
610:
611: ELSIF p_entity_level = 'PO_LINE' THEN
612:
613: DELETE FROM po_lines_all_ext_b
614: WHERE ( draft_id = p_draft_id -- main record for Mod
615: AND po_line_id = p_entity_id)
616: OR ( draft_id = -p_draft_id -- delta record for complex pricing
617: AND po_line_id = -p_entity_id