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 JTF_RS_RESOURCE_EXTNS

Line 854: JTF_RS_RESOURCE_EXTNS RES

850: JTF_RS_ROLE_RELATIONS rrel,
851: JTF_RS_ROLES_B role,
852: JTF_RS_GROUP_USAGES u,
853: JTF_RS_GROUPS_B grp,
854: JTF_RS_RESOURCE_EXTNS RES
855: WHERE mem.group_member_id = rrel.role_resource_id AND
856: rrel.role_resource_type = 'RS_GROUP_MEMBER' AND
857: rrel.role_id = role.role_id AND
858: role.role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM') AND

Line 887: FROM jtf_rs_resource_extns

883: WHERE lead_id = pc_lead_id;
884:
885: /* CURSOR lc_address (pc_party_relation_id number) is
886: SELECT address_id, resource_id
887: FROM jtf_rs_resource_extns
888: WHERE category = 'PARTNER'
889: and sysdate between start_date_active and nvl(end_date_active,sysdate)
890: AND source_id = pc_party_relation_id; */
891:

Line 898: FROM jtf_rs_resource_extns a,

894: -- address_id directly from TCA.
895: -- --------------------------------------------------------------------------
896: CURSOR lc_address (pc_party_relation_id number) is
897: SELECT b.address_id, a.resource_id
898: FROM jtf_rs_resource_extns a,
899: as_party_addresses_v b,
900: pv_partner_profiles c
901: WHERE a.category = 'PARTNER'
902: AND sysdate between a.start_date_active and nvl(a.end_date_active,sysdate)

Line 1620: l_resource_id jtf_rs_resource_extns.resource_id%type;

1616: l_workflow_id NUMBER;
1617: l_user_id NUMBER;
1618: l_user_name fnd_user.user_name%type;
1619: l_creating_username fnd_user.user_name%type;
1620: l_resource_id jtf_rs_resource_extns.resource_id%type;
1621: l_category jtf_rs_resource_extns.category%type;
1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;

Line 1621: l_category jtf_rs_resource_extns.category%type;

1617: l_user_id NUMBER;
1618: l_user_name fnd_user.user_name%type;
1619: l_creating_username fnd_user.user_name%type;
1620: l_resource_id jtf_rs_resource_extns.resource_id%type;
1621: l_category jtf_rs_resource_extns.category%type;
1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;
1625: l_customer_id as_leads_all.customer_id%TYPE;

Line 1622: l_party_id jtf_rs_resource_extns.source_id%type;

1618: l_user_name fnd_user.user_name%type;
1619: l_creating_username fnd_user.user_name%type;
1620: l_resource_id jtf_rs_resource_extns.resource_id%type;
1621: l_category jtf_rs_resource_extns.category%type;
1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;
1625: l_customer_id as_leads_all.customer_id%TYPE;
1626: l_address_id as_leads_all.address_id%TYPE;

Line 1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;

1619: l_creating_username fnd_user.user_name%type;
1620: l_resource_id jtf_rs_resource_extns.resource_id%type;
1621: l_category jtf_rs_resource_extns.category%type;
1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;
1625: l_customer_id as_leads_all.customer_id%TYPE;
1626: l_address_id as_leads_all.address_id%TYPE;
1627: l_wf_item_type VARCHAR2(20);

Line 1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;

1620: l_resource_id jtf_rs_resource_extns.resource_id%type;
1621: l_category jtf_rs_resource_extns.category%type;
1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;
1625: l_customer_id as_leads_all.customer_id%TYPE;
1626: l_address_id as_leads_all.address_id%TYPE;
1627: l_wf_item_type VARCHAR2(20);
1628: l_wf_item_key VARCHAR2(20);

Line 1669: jtf_rs_resource_extns extn,

1665: decode(pn.notification_type, 'MATCHED_TO', 0, pa.partner_id) partner_id
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

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

Line 1741: FROM fnd_user fu, jtf_rs_resource_extns js

1737: AND ld.lead_id = pc_lead_id;
1738:
1739: CURSOR lc_get_pt_emp_cat(pc_salesforce_id NUMBER) IS
1740: SELECT js.source_id, js.category, js.source_business_grp_name, fu.user_name
1741: FROM fnd_user fu, jtf_rs_resource_extns js
1742: WHERE fu.user_id = js.user_id
1743: AND js.resource_id = pc_salesforce_id;
1744:
1745: CURSOR lc_get_pt_ven_name(pc_party_id NUMBER) IS

Line 2599: FROM fnd_user fu, jtf_rs_resource_extns js

2595:
2596: -- Get the Party id of the relation from based on the resource id
2597: SELECT js.source_id, fu.user_name, js.category
2598: INTO l_party_id, x_user_name, l_resource_category
2599: FROM fnd_user fu, jtf_rs_resource_extns js
2600: WHERE fu.user_id = js.user_id
2601: AND js.resource_id = p_salesforce_id;
2602:
2603: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN