[Home] [Help]
730: FROM mtl_item_catalog_groups_b ic
731: WHERE EXISTS
732: (SELECT olc.object_classification_code CatalogId
733: FROM EGO_OBJ_TYPE_LIFECYCLES olc
734: WHERE olc.object_id = (SELECT OBJECT_ID FROM fnd_objects WHERE obj_name = 'EGO_ITEM')
735: AND olc.lifecycle_id = ITEM_DTLS.lifecycle_id
736: AND olc.object_classification_code = ic.item_catalog_group_id)
737: AND ROWNUM = 1
738: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
4117:
4118: /* Cursor to fetch the assignees with direct item roles at item level */
4119: CURSOR c_item_assignee(cp_assignee_role_id NUMBER, cp_item_id NUMBER, cp_org_id NUMBER) IS
4120: SELECT party.party_id, party.party_name, party.party_type
4121: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4122: WHERE obj.obj_name = 'EGO_ITEM'
4123: AND grants.object_id = obj.object_id
4124: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4125: AND (
4136:
4137: /* Cursor to fetch the assignees with item roles at catalog category level */
4138: CURSOR c_category_item_assignee(cp_assignee_role_id NUMBER, cp_item_id NUMBER, cp_org_id NUMBER) IS
4139: SELECT party.party_id, party.party_name, party.party_type
4140: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4141: WHERE obj.obj_name = 'EGO_ITEM'
4142: AND grants.object_id = obj.object_id
4143: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4144: AND (
4160:
4161: /* Cursor to fetch the assignees with item roles at organization level */
4162: CURSOR c_org_assignee(cp_assignee_role_id NUMBER, cp_org_id NUMBER) IS
4163: SELECT party.party_id, party.party_name, party.party_type
4164: FROM HZ_PARTIES party, fnd_grants grants, fnd_objects obj
4165: WHERE obj.obj_name = 'EGO_ITEM'
4166: AND grants.object_id = obj.object_id
4167: AND grants.GRANTEE_ORIG_SYSTEM_ID = party.party_id
4168: AND (