DBA Data[Home] [Help]

APPS.ENG_NIR_UTIL_PKG dependencies on MTL_ITEM_CATALOG_GROUPS_V

Line 447: FROM eng_change_route_assocs a, mtl_item_catalog_groups_v b

443: SELECT a.route_association_id,
444: b.item_catalog_group_id,
445: b.parent_catalog_group_id,
446: b.NEW_ITEM_REQUEST_REQD
447: FROM eng_change_route_assocs a, mtl_item_catalog_groups_v b
448: WHERE a.assoc_obj_pk1_value = b.item_catalog_group_id
449: AND a.object_id1= rec.object_id1
450: AND To_Char(a.CREATION_DATE, 'DD-MON-YYYY HH24:MI:SS') = rec.creation_date
451: ) CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id AND NEW_ITEM_REQUEST_REQD = 'I'