APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_RTG_ITEM_REVISIONS

Line 179: FROM MTL_RTG_ITEM_REVISIONS

175: l_routing_rev VARCHAR2(3) := NULL;
176:
177: CURSOR RTG_REV IS
178: SELECT process_revision
179: FROM MTL_RTG_ITEM_REVISIONS
180: WHERE inventory_item_id = p_revised_item_id
181: AND organization_id = p_organization_id
182: ORDER BY effectivity_date desc, process_revision desc;
183:

Line 613: FROM MTL_RTG_ITEM_REVISIONS

609: l_current_revision VARCHAR2(3) := NULL;
610:
611: CURSOR NO_ECO_ROUTING_REV IS
612: SELECT process_revision
613: FROM MTL_RTG_ITEM_REVISIONS
614: WHERE INVENTORY_ITEM_ID = p_revised_item_id
615: AND ORGANIZATION_ID = p_organization_id
616: AND EFFECTIVITY_DATE <= p_revision_date
617: AND IMPLEMENTATION_DATE IS NOT NULL

Line 630: FROM MTL_RTG_ITEM_REVISIONS

626: INTO l_current_revision
627: FROM MTL_PARAMETERS mp
628: WHERE mp.organization_id = p_organization_id
629: AND NOT EXISTS( SELECT NULL
630: FROM MTL_RTG_ITEM_REVISIONS
631: WHERE implementation_date IS NOT NULL
632: AND organization_id = p_organization_id
633: AND inventory_item_id = p_revised_item_id
634: ) ;

Line 679: FROM MTL_RTG_ITEM_REVISIONS

675: l_Pending_Rev NUMBER := 0;
676: l_rev_sequence NUMBER;
677:
678: CURSOR c1 IS SELECT change_notice
679: FROM MTL_RTG_ITEM_REVISIONS
680: WHERE inventory_item_id = p_revised_item_id
681: AND organization_id = p_organization_id
682: AND process_revision = p_new_routing_revision
683: AND revised_item_sequence_id <>

Line 689: FROM MTL_RTG_ITEM_REVISIONS

685: revised_item_sequence_id+99)
686: AND implementation_date is null;
687:
688: CURSOR c2 IS SELECT 1
689: FROM MTL_RTG_ITEM_REVISIONS
690: WHERE inventory_item_id = p_revised_item_id
691: AND organization_id = p_organization_id
692: AND process_revision = p_new_routing_revision
693: AND implementation_date is not null;