2263: , l_rev_operation_rec.eco_name
2264: , SYSDATE
2265: , SYSDATE
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
2580: , l_rev_operation_rec.eco_name
2581: , SYSDATE
2582: , SYSDATE
2583: , l_rev_op_unexp_rec.revised_item_sequence_id
2584: FROM MTL_PARAMETERS mp
2585: WHERE mp.organization_id = l_rev_op_unexp_rec.organization_id
2586: AND NOT EXISTS( SELECT NULL
2587: FROM MTL_RTG_ITEM_REVISIONS
2588: WHERE implementation_date IS NOT NULL