eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_DATA_SECURITY dependencies on FND_OBJECT_INSTANCE_SETS

Line 1149: ' FROM fnd_object_instance_sets sets '||

1145: --
1146:
1147: l_dynamic_sql_1 :=
1148: ' SELECT sets.instance_SET_ID, sets.predicate ' ||
1149: ' FROM fnd_object_instance_sets sets '||
1150: ' WHERE (sets.instance_set_id, sets.object_id) IN ' ||
1151: ' (SELECT grants.instance_set_id, grants.object_id ' ||
1152: ' FROM fnd_grants grants '||
1153: ' WHERE grants.object_id = :object_id '||

Line 1663: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||

1659: l_set_predicates := '(';
1660: l_set_predicate_segment := '';
1661: l_dynamic_sql_1 :=
1662: ' SELECT DISTINCT instance_sets.predicate ' ||
1663: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||
1664: ' WHERE grants.instance_type = :instance_type '||
1665: ' AND grants.start_date <= SYSDATE ' ||
1666: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
1667: ' AND grants.instance_set_id = instance_sets.instance_set_id ' ||

Line 2156: ' fnd_object_instance_sets sets '||

2152:
2153: l_dynamic_sql_1 :=
2154: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
2155: ' FROM fnd_grants grants, ' ||
2156: ' fnd_object_instance_sets sets '||
2157: ' WHERE grants.instance_type = :instance_type '||
2158: ' AND grants.start_date <= SYSDATE ' ||
2159: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2160: ' AND grants.instance_set_id = sets.instance_set_id ' ||

Line 2843: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||

2839: -- Now we build dynamic SQL using the work we just did to optimize the query --
2840: -------------------------------------------------------------------------------
2841: l_dynamic_sql_1 :=
2842: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
2843: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||
2844: ' WHERE grants.object_id = :object_id ' ||
2845: ' AND grants.start_date <= SYSDATE ' ||
2846: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
2847: ' AND grants.instance_type = :instance_type ' ||

Line 3775: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

3771: -------------------------------------------------------------------------------
3772: l_dynamic_sql_1 :=
3773: ' SELECT DISTINCT instance_sets.predicate ' ||
3774: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
3775: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
3776: ' WHERE grants.instance_type = :instance_type ' ||
3777: ' AND grants.start_date <= SYSDATE ' ||
3778: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
3779: ' AND cmf.function_id = functions.function_id ' ||

Line 4333: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

4329: IF(l_instance_set_flag = TRUE) THEN
4330: l_dynamic_sql_1 :=
4331: ' SELECT DISTINCT instance_sets.predicate ' ||
4332: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
4333: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
4334: ' WHERE grants.instance_type = :instance_type ' ||
4335: ' AND grants.start_date <= SYSDATE ' ||
4336: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4337: ' AND cmf.function_id = functions.function_id ' ||

Line 4823: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

4819: IF(l_instance_set_flag = TRUE) THEN
4820: l_dynamic_sql :=
4821: ' SELECT DISTINCT instance_sets.predicate ' ||
4822: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
4823: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
4824: ' WHERE grants.instance_type = :instance_type ' ||
4825: ' AND grants.start_date <= SYSDATE ' ||
4826: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
4827: ' AND cmf.function_id = functions.function_id ' ||

Line 5117: fnd_object_instance_sets instance_sets

5113: )
5114: IS
5115: SELECT DISTINCT instance_sets.predicate
5116: FROM fnd_grants grants,
5117: fnd_object_instance_sets instance_sets
5118: WHERE grants.instance_type = 'SET'
5119: AND grants.start_date <= SYSDATE
5120: AND ( grants.end_date IS NULL
5121: OR grants.end_date >= SYSDATE )

Line 5528: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

5524: IF(l_instance_set_flag = TRUE) THEN
5525: l_dynamic_sql_1 :=
5526: ' SELECT DISTINCT instance_sets.predicate ' ||
5527: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
5528: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
5529: ' WHERE grants.instance_type = :instance_type ' ||
5530: ' AND grants.start_date <= SYSDATE ' ||
5531: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
5532: ' AND cmf.function_id = functions.function_id ' ||

Line 5589: ' fnd_object_instance_sets instance_sets,' ||

5585:
5586: l_dynamic_sql_2 :=
5587: ' SELECT DISTINCT instance_sets.predicate '||
5588: ' FROM fnd_grants grants, '||
5589: ' fnd_object_instance_sets instance_sets,' ||
5590: ' fnd_form_functions F, fnd_menu_entries R, '||
5591: ' fnd_menus M, ego_obj_role_mappings P '||
5592: ' WHERE grants.instance_type = ''SET'' '||
5593: ' AND grants.start_date <= SYSDATE ' ||

Line 6189: from fnd_objects o, fnd_object_instance_sets s

6185: l_pk2_col_type,
6186: l_pk3_col_type,
6187: l_pk4_col_type,
6188: l_pk5_col_type
6189: from fnd_objects o, fnd_object_instance_sets s
6190: where s.instance_set_name = p_instance_set_name
6191: and s.object_id = o.object_id;
6192: exception
6193: when no_data_found then

Line 6198: 'fnd_objects and fnd_object_instance_sets for instance set '||

6194: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6195: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6196: fnd_message.set_token('REASON',
6197: 'Data Error- couldn''t get predicate and/or object_name from '||
6198: 'fnd_objects and fnd_object_instance_sets for instance set '||
6199: '"'||p_instance_set_name||'"');
6200: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6201: ,p_module => l_api_name
6202: ,p_message => 'The given data is not sufficient to find a valid instance set '

Line 7381: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||

7377: -- Now we build dynamic SQL using the work we just did to optimize the query --
7378: -------------------------------------------------------------------------------
7379: l_dynamic_sql_1 :=
7380: ' SELECT DISTINCT sets.instance_set_id, sets.predicate ' ||
7381: ' FROM fnd_grants grants, fnd_object_instance_sets sets' ||
7382: ' WHERE grants.object_id = :object_id ' ||
7383: ' AND grants.start_date <= SYSDATE ' ||
7384: ' AND NVL(grants.end_date, SYSDATE) >= SYSDATE ' ||
7385: ' AND grants.instance_type = :instance_type ' ||

Line 8095: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||

8091: l_set_predicate_segment := '';
8092:
8093: l_dynamic_sql_1 :=
8094: ' SELECT DISTINCT instance_sets.predicate ' ||
8095: ' FROM fnd_grants grants, fnd_object_instance_sets instance_sets ' ||
8096: ' WHERE grants.instance_type = :instance_type '||
8097: ' AND grants.start_date <= SYSDATE ' ||
8098: ' AND (grants.end_date IS NULL OR grants.end_date >= SYSDATE) ' ||
8099: ' AND grants.instance_set_id = instance_sets.instance_set_id ' ||