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_OPPORTUNITY_VHUK dependencies on AS_ACCESSES_ALL

Line 1090: for c_check in (select 1 from as_accesses_all where

1086:
1087: FOR i in l_rs_details_tbl.first .. l_rs_details_tbl.last LOOP
1088:
1089: -- skip if resource already on salesteam
1090: for c_check in (select 1 from as_accesses_all where
1091: salesforce_id <> l_rs_details_tbl(i).resource_id and lead_id = l_lead_id)
1092: loop
1093: -- The returned table has all CM from Vendor and VAD.
1094: -- Since VAD CM does not have person id, we need to populate partner_cont_party_id

Line 1670: as_accesses_all asac,

1666: FROM pv_lead_workflows pw,
1667: pv_lead_assignments pa,
1668: pv_party_notifications pn,
1669: jtf_rs_resource_extns extn,
1670: as_accesses_all asac,
1671: fnd_user fu
1672: WHERE pw.wf_item_type = pa.wf_item_type
1673: and pw.wf_item_key = pa.wf_item_key
1674: AND pa.lead_assignment_id = pn.lead_assignment_id

Line 1692: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu, pv_lead_workflows pw

1688: AND sysdate between fu.start_date and nvl(fu.end_date,sysdate)
1689: UNION
1690: SELECT js.user_id, js.resource_id, fu.user_name,
1691: decode(pw.created_by - js.user_id,0,'AM','OTHER') user_type, 0 partner_id
1692: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu, pv_lead_workflows pw
1693: WHERE (('Y' = pc_notify_ot_flag and pw.created_by <> js.user_id)
1694: or ('Y' = pc_notify_am_flag and pw.created_by = js.user_id))
1695: AND ac.lead_id = pc_lead_id
1696: and ac.lead_id = pw.lead_id