APPS.ENG_CHANGE_ROLES_PUB dependencies on ENG_REVISED_ITEMS

Line 186: SELECT revised_item_id, organization_id FROM eng_revised_items WHERE change_id = p_pk1_value; -- p_pk1_value = change_id

182: CURSOR change_subjects_cur is
183: SELECT pk1_value, pk2_value FROM eng_change_subjects where change_id = p_pk1_value;
184:
185: CURSOR change_rev_items_cur is
186: SELECT revised_item_id, organization_id FROM eng_revised_items WHERE change_id = p_pk1_value; -- p_pk1_value = change_id
187:
188: l_grantee_list GRANTEES_TBL_TYPE;
189: l_index NUMBER;
190: l_revised_item_id NUMBER;

Line 807: 'eng_revised_items rev_items ' ||

803: 'ego_obj_role_mappings mapping, ' ||
804: 'fnd_objects obj,' ||
805: 'eng_engineering_changes changes,' ||
806: 'eng_change_subjects subjects,' ||
807: 'eng_revised_items rev_items ' ||
808: 'WHERE grants.grantee_type = ''USER'' ' ||
809: 'AND grants.object_id = obj.object_id ' ||
810: 'AND mapping.parent_object_id = grants.object_id ' ||
811: 'AND mapping.parent_role_id = grants.menu_id ' ||

Line 873: 'eng_revised_ITEMS REV_ITEMS ' ||

869: 'ego_obj_role_mappings mapping, ' ||
870: 'fnd_objects obj , ' ||
871: 'eng_engineering_changes changes, ' ||
872: 'eng_change_subjects subjects, ' ||
873: 'eng_revised_ITEMS REV_ITEMS ' ||
874: 'WHERE grants.grantee_type = ''GROUP'' ' ||
875: 'AND grants.object_id = obj.object_id ' ||
876: 'AND mapping.parent_object_id = grants.object_id ' ||
877: 'AND mapping.parent_role_id = grants.menu_id ' ||

Line 934: 'eng_revised_items rev_items ' ||

930: 'ego_obj_role_mappings mapping, ' ||
931: 'fnd_objects obj, ' ||
932: 'eng_engineering_changes changes, ' ||
933: 'eng_change_subjects subjects, ' ||
934: 'eng_revised_items rev_items ' ||
935: 'WHERE grants.grantee_type = ''COMPANY'' ' ||
936: 'AND grants.object_id = obj.object_id ' ||
937: 'AND grantee_company.party_type = ''ORGANIZATION'' ' ||
938: 'AND mapping.parent_object_id = grants.object_id ' ||

Line 998: 'eng_revised_items rev_items ' ||

994: 'ego_obj_role_mappings mapping, ' ||
995: 'fnd_objects obj, ' ||
996: 'eng_engineering_changes changes, ' ||
997: 'eng_change_subjects subjects, ' ||
998: 'eng_revised_items rev_items ' ||
999: 'WHERE grants.grantee_type = ''GLOBAL'' ' ||
1000: 'AND grants.object_id = obj.object_id ' ||
1001: 'AND mapping.parent_object_id = grants.object_id ' ||
1002: 'AND mapping.parent_role_id = grants.menu_id ' ||