DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on FND_OBJECT_INSTANCE_SETS

Line 4153: FROM fnd_object_instance_sets instance_set, mtl_system_items_b item1

4149: AND NVL(grants.end_date, SYSDATE+1) >= TRUNC(SYSDATE)
4150: AND grants.instance_type= 'SET'
4151: AND grants.menu_id = cp_assignee_role_id
4152: AND grants.instance_set_id IN ( SELECT instance_set.instance_set_id
4153: FROM fnd_object_instance_sets instance_set, mtl_system_items_b item1
4154: WHERE instance_set.object_id = grants.object_id
4155: AND instance_set.instance_set_name = 'EGO_ORG_CAT_ITEM_' ||
4156: to_char(item1.organization_id) || '_' || to_char(item1.ITEM_CATALOG_GROUP_ID)
4157: AND item1.INVENTORY_ITEM_ID= cp_item_id

Line 4177: FROM fnd_object_instance_sets instance_set

4173: AND NVL(grants.end_date, SYSDATE+1) >= TRUNC(SYSDATE)
4174: AND grants.instance_type= 'SET'
4175: AND grants.menu_id = cp_assignee_role_id
4176: AND grants.instance_set_id IN ( SELECT instance_set.instance_set_id
4177: FROM fnd_object_instance_sets instance_set
4178: WHERE instance_set.object_id = grants.object_id
4179: AND instance_set.instance_set_name = 'EGO_ORG_ITEM_' ||cp_org_id)
4180: AND ROWNUM = 1;
4181: