APPS.PV_ASSIGNMENT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 729: jtf_rs_resource_extns LEAD_SOURCE,

725: hz_relationships ORG_TO_VEND,
726: hz_organization_profiles HZOP,
727: pv_lead_assignments PV_ASSIGN,
728: pv_lead_workflows PV_LEAD_WF,
729: jtf_rs_resource_extns LEAD_SOURCE,
730: pv_enty_attr_values PEAV
731: where PV_ASSIGN.lead_assignment_id = pc_lead_assignment_id
732: and PV_ASSIGN.wf_item_type = PV_LEAD_WF.wf_item_type
733: and PV_ASSIGN.wf_item_key = PV_LEAD_WF.wf_item_key

Line 759: jtf_rs_resource_extns extn

755:
756: CURSOR lc_get_user_type (pc_user_id NUMBER) IS
757: SELECT extn.category
758: FROM fnd_user fuser,
759: jtf_rs_resource_extns extn
760: WHERE fuser.user_id = pc_user_id
761: AND fuser.user_id = extn.user_id;
762:
763: begin

Line 1182: jtf_rs_resource_extns b,

1178: a1.lead_id, d.user_name access_user, a2.resource_id
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

Line 1217: jtf_rs_resource_extns b,

1213: select
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

Line 1245: jtf_rs_resource_extns c,

1241: from
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

Line 1270: jtf_rs_resource_extns b,

1266: a1.lead_id, d.user_name access_user, a2.resource_id
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

Line 1300: jtf_rs_resource_extns b,

1296: select
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

Line 1322: jtf_rs_resource_extns c,

1318: FROM
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

Line 1345: jtf_rs_resource_extns b,

1341: SELECT
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

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

Line 3548: jtf_rs_resource_extns_vl c

3544: pc_response varchar2) is
3545: select c.resource_name
3546: from pv_lead_assignments a,
3547: pv_party_notifications b,
3548: jtf_rs_resource_extns_vl c
3549: where a.wf_item_type = pc_itemtype
3550: and a.wf_item_key = pc_itemkey
3551: and a.partner_id = pc_partner_id
3552: and a.lead_assignment_id = b.lead_assignment_id