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.PV_ASSIGNMENT_PVT dependencies on AS_ACCESSES_ALL

Line 1183: as_accesses_all c,

1179: from
1180: pv_lead_assignments a1,
1181: pv_party_notifications a2,
1182: jtf_rs_resource_extns b,
1183: as_accesses_all c,
1184: fnd_user d
1185: where
1186: a1.wf_item_type = pc_itemtype
1187: and a1.wf_item_key = pc_itemkey

Line 1218: as_accesses_all c

1214: a.lead_id, 'PARTNER', b.resource_id
1215: from
1216: pv_lead_assignments a,
1217: jtf_rs_resource_extns b,
1218: as_accesses_all c
1219: where
1220: a.wf_item_type = pc_itemtype
1221: and a.wf_item_key = pc_itemkey
1222: and a.status in ( pv_assignment_pub.g_la_status_cm_rejected,

Line 1246: as_accesses_all d

1242: pv_lead_assignments la,
1243: pv_partner_profiles pvpp,
1244: hz_relationships b,
1245: jtf_rs_resource_extns c,
1246: as_accesses_all d
1247: where
1248: la.wf_item_type = pc_itemtype and
1249: la.wf_item_key = pc_itemkey and
1250: la.partner_id = pc_partner_id and

Line 1271: as_accesses_all c,

1267: from
1268: pv_lead_assignments a1,
1269: pv_party_notifications a2,
1270: jtf_rs_resource_extns b,
1271: as_accesses_all c,
1272: fnd_user d
1273: where
1274: a1.wf_item_type = pc_itemtype
1275: and a1.wf_item_key = pc_itemkey

Line 1301: as_accesses_all c

1297: c.lead_id, 'PARTNER', b.resource_id
1298: from
1299: pv_lead_assignments la,
1300: jtf_rs_resource_extns b,
1301: as_accesses_all c
1302: where
1303: la.wf_item_type = pc_itemtype and
1304: la.wf_item_key = pc_itemkey and
1305: la.partner_id = pc_partner_id and

Line 1323: as_accesses_all d

1319: pv_lead_assignments la,
1320: pv_partner_profiles pvpp,
1321: hz_relationships b,
1322: jtf_rs_resource_extns c,
1323: as_accesses_all d
1324: WHERE
1325: la.wf_item_type = pc_itemtype
1326: AND la.wf_item_key = pc_itemkey
1327: AND la.partner_id = pvpp.partner_id

Line 1346: as_accesses_all c

1342: c.lead_id, 'PARTNER', b.resource_id
1343: FROM
1344: pv_lead_assignments la,
1345: jtf_rs_resource_extns b,
1346: as_accesses_all c
1347: WHERE
1348: la.wf_item_type = pc_itemtype
1349: AND la.wf_item_key = pc_itemkey
1350: AND la.partner_id = b.source_id

Line 3502: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu,

3498: union
3499: SELECT js.user_id, js.resource_id, fu.user_name,
3500: decode(pw.created_by - js.user_id,0,'AM','OT') user_type,
3501: decode(pc_ignore_pt_flag, 'Y', 0, pl.partner_id) partner_id, pl.status
3502: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu,
3503: pv_lead_workflows pw, pv_lead_assignments pl
3504: WHERE (('Y' = pc_notify_ot_flag and pw.created_by <> js.user_id)
3505: or ('Y' = pc_notify_am_flag and pw.created_by = js.user_id))
3506: AND ac.lead_id = pc_lead_id