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.OZF_CLAIM_ACCRUAL_PVT dependencies on AMS_ACT_ACCESS

Line 1340: FND_DSQL.add_text(' EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');

1336: IF (l_sales_rep = FND_API.g_true AND NOT l_is_admin ) THEN
1337: FND_DSQL.add_text(' AND (o.confidential_flag =''N'' OR ');
1338: FND_DSQL.add_text(' o.confidential_flag IS NULL OR ');
1339: FND_DSQL.add_text(' ( NVL(o.budget_offer_yn, ''N'') = ''N'' AND ');
1340: FND_DSQL.add_text(' EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');
1341: FND_DSQL.add_text(' WHERE act.object_id = o.qp_list_header_id ');
1342: FND_DSQL.add_text(' AND act.object_type = ''OFFR'' ');
1343: FND_DSQL.add_text(' AND act.resource_id= ');
1344: FND_DSQL.add_bind(l_resource_id);

Line 1347: FND_DSQL.add_text(' AND EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');

1343: FND_DSQL.add_text(' AND act.resource_id= ');
1344: FND_DSQL.add_bind(l_resource_id);
1345: FND_DSQL.add_text('))');
1346: FND_DSQL.add_text(' OR ( NVL(o.budget_offer_yn, ''N'') = ''Y'' ');
1347: FND_DSQL.add_text(' AND EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');
1348: FND_DSQL.add_text(' WHERE act.object_id = fu.fund_id ');
1349: FND_DSQL.add_text(' AND act.object_type = ''FUND'' ');
1350: FND_DSQL.add_text(' AND act.resource_id= ' );
1351: FND_DSQL.add_bind(l_resource_id);

Line 12137: FROM ams_act_access

12133: AND cla.claim_id = line.claim_id
12134: AND line.activity_id = req.request_header_id
12135: AND req.enabled_flag = 'Y'
12136: AND NOT EXISTS ( SELECT NULL
12137: FROM ams_act_access
12138: WHERE user_or_role_id = req.resource_id
12139: AND arc_user_or_role_type = 'USER'
12140: AND arc_act_access_to_object = 'CLAM'
12141: );