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 1167: FND_DSQL.add_text(' EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');

1163: IF (l_sales_rep = FND_API.g_true AND NOT l_is_admin ) THEN
1164: FND_DSQL.add_text(' AND (o.confidential_flag =''N'' OR ');
1165: FND_DSQL.add_text(' o.confidential_flag IS NULL OR ');
1166: FND_DSQL.add_text(' ( NVL(o.budget_offer_yn, ''N'') = ''N'' AND ');
1167: FND_DSQL.add_text(' EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');
1168: FND_DSQL.add_text(' WHERE act.object_id = o.qp_list_header_id ');
1169: FND_DSQL.add_text(' AND act.object_type = ''OFFR'' ');
1170: FND_DSQL.add_text(' AND act.resource_id= ');
1171: FND_DSQL.add_bind(l_resource_id);

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

1170: FND_DSQL.add_text(' AND act.resource_id= ');
1171: FND_DSQL.add_bind(l_resource_id);
1172: FND_DSQL.add_text('))');
1173: FND_DSQL.add_text(' OR ( NVL(o.budget_offer_yn, ''N'') = ''Y'' ');
1174: FND_DSQL.add_text(' AND EXISTS ( SELECT 1 FROM ams_act_access_denorm act ');
1175: FND_DSQL.add_text(' WHERE act.object_id = fu.fund_id ');
1176: FND_DSQL.add_text(' AND act.object_type = ''FUND'' ');
1177: FND_DSQL.add_text(' AND act.resource_id= ' );
1178: FND_DSQL.add_bind(l_resource_id);

Line 9849: FROM ams_act_access

9845: AND cla.claim_id = line.claim_id
9846: AND line.activity_id = req.request_header_id
9847: AND req.enabled_flag = 'Y'
9848: AND NOT EXISTS ( SELECT NULL
9849: FROM ams_act_access
9850: WHERE user_or_role_id = req.resource_id
9851: AND arc_user_or_role_type = 'USER'
9852: AND arc_act_access_to_object = 'CLAM'
9853: );