DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_LINES_ALL_EXT_TL

Line 578: DELETE FROM po_lines_all_ext_tl

574: FROM po_lines_draft_all
575: WHERE po_header_id = p_entity_id
576: AND draft_id = p_draft_id));
577:
578: DELETE FROM po_lines_all_ext_tl
579: WHERE (draft_id = p_draft_id --main record for Mod
580: AND po_line_id IN (SELECT po_line_id
581: FROM po_lines_draft_all
582: WHERE po_header_id = p_entity_id

Line 630: DELETE FROM po_lines_all_ext_tl

626: FROM po_line_locations_draft_all
627: WHERE po_line_id = p_entity_id
628: AND draft_id = p_draft_id);
629:
630: DELETE FROM po_lines_all_ext_tl
631: WHERE ( draft_id = p_draft_id -- main record for Mod
632: AND po_line_id = p_entity_id)
633: OR ( draft_id = -p_draft_id -- delta record for complex pricing
634: AND po_line_id = -p_entity_id