DBA Data[Home] [Help]

APPS.ENG_GLOBALS dependencies on MTL_RTG_ITEM_REVISIONS

Line 2238: INSERT INTO MTL_RTG_ITEM_REVISIONS

2234: l_mesg_token_Tbl := l_temp_Mesg_Token_Tbl ;
2235:
2236: ELSE
2237: -- Create a new routing revision for the created primary routing
2238: INSERT INTO MTL_RTG_ITEM_REVISIONS
2239: ( inventory_item_id
2240: , organization_id
2241: , process_revision
2242: , implementation_date

Line 2270: FROM MTL_RTG_ITEM_REVISIONS

2266: , l_rev_op_unexp_rec.revised_item_sequence_id
2267: FROM MTL_PARAMETERS mp
2268: WHERE mp.organization_id = l_rev_op_unexp_rec.organization_id
2269: AND NOT EXISTS( SELECT NULL
2270: FROM MTL_RTG_ITEM_REVISIONS
2271: WHERE implementation_date IS NOT NULL
2272: AND organization_id = l_rev_op_unexp_rec.organization_id
2273: AND inventory_item_id = l_rev_op_unexp_rec.revised_item_id
2274: ) ;