APPS.PO_MOD_CONTROL_PVT dependencies on PO_LINE_LOCATIONS_ALL

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 604: DELETE FROM po_line_locations_all_ext_tl

600: FROM po_line_locations_draft_all
601: WHERE po_header_id = p_entity_id
602: AND draft_id = p_draft_id);
603:
604: DELETE FROM po_line_locations_all_ext_tl
605: WHERE draft_id = p_draft_id
606: AND line_location_id IN(SELECT line_location_id
607: FROM po_line_locations_draft_all
608: 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 640: DELETE FROM po_line_locations_all_ext_tl

636: OR ( draft_id = -1 -- old record for complex pricing
637: AND po_line_id = p_entity_id
638: AND pk1_value = p_draft_id);
639:
640: DELETE FROM po_line_locations_all_ext_tl
641: WHERE draft_id = p_draft_id
642: AND line_location_id IN (SELECT line_location_id
643: FROM po_line_locations_draft_all
644: 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

Line 653: DELETE FROM po_line_locations_all_ext_tl

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
654: WHERE draft_id = p_draft_id
655: AND line_location_id = p_entity_id;
656:
657: END IF;

Line 993: FROM po_line_locations_all poll1,

989: INTO l_ship_invalid_for_ctrl_actn
990: FROM DUAL
991: WHERE EXISTS(
992: SELECT 1
993: FROM po_line_locations_all poll1,
994: po_line_locations_all poll2
995: WHERE poll1.line_location_id = p_doc_level_id
996: AND poll1.po_line_id = poll2.po_line_id
997: AND NVL(poll2.cancel_flag,'N') <> 'Y'

Line 994: po_line_locations_all poll2

990: FROM DUAL
991: WHERE EXISTS(
992: SELECT 1
993: FROM po_line_locations_all poll1,
994: po_line_locations_all poll2
995: WHERE poll1.line_location_id = p_doc_level_id
996: AND poll1.po_line_id = poll2.po_line_id
997: AND NVL(poll2.cancel_flag,'N') <> 'Y'
998: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --