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.CN_SRP_HIER_PROC_PVT dependencies on JTF_RS_GROUP_USAGES

Line 1191: FROM jtf_rs_groups_vl g, jtf_rs_group_usages u

1187: SELECT
1188: g.group_id group_id,
1189: trunc(g.start_date_active) start_date,
1190: trunc(g.end_date_active) end_date
1191: FROM jtf_rs_groups_vl g, jtf_rs_group_usages u
1192: WHERE
1193: g.group_id = p_group_id
1194: AND g.group_id = u.group_id
1195: AND u.usage='SF_PLANNING'

Line 1202: jtf_rs_group_usages u1,

1198: SELECT r.group_id group_id,
1199: trunc(r.start_date_active) start_date,
1200: trunc(r.end_date_active) end_date
1201: FROM jtf_rs_grp_relations r,
1202: jtf_rs_group_usages u1,
1203: jtf_rs_group_usages u2
1204: WHERE
1205: u1.group_id = r.group_id
1206: AND u2.group_id = r.related_group_id

Line 1203: jtf_rs_group_usages u2

1199: trunc(r.start_date_active) start_date,
1200: trunc(r.end_date_active) end_date
1201: FROM jtf_rs_grp_relations r,
1202: jtf_rs_group_usages u1,
1203: jtf_rs_group_usages u2
1204: WHERE
1205: u1.group_id = r.group_id
1206: AND u2.group_id = r.related_group_id
1207: AND u1.usage='SF_PLANNING'

Line 1418: FROM jtf_rs_groups_vl g, jtf_rs_group_usages u

1414: SELECT
1415: g.group_id group_id,
1416: trunc(g.start_date_active) start_date,
1417: trunc(g.end_date_active) end_date
1418: FROM jtf_rs_groups_vl g, jtf_rs_group_usages u
1419: WHERE
1420: g.group_id = p_group_id
1421: AND g.group_id = u.group_id
1422: AND u.usage='SF_PLANNING'

Line 1429: jtf_rs_group_usages u1,

1425: SELECT r.group_id group_id,
1426: trunc(r.start_date_active) start_date,
1427: trunc(r.end_date_active) end_date
1428: FROM jtf_rs_grp_relations r,
1429: jtf_rs_group_usages u1,
1430: jtf_rs_group_usages u2
1431: WHERE
1432: u1.group_id = r.group_id
1433: AND u2.group_id = r.related_group_id

Line 1430: jtf_rs_group_usages u2

1426: trunc(r.start_date_active) start_date,
1427: trunc(r.end_date_active) end_date
1428: FROM jtf_rs_grp_relations r,
1429: jtf_rs_group_usages u1,
1430: jtf_rs_group_usages u2
1431: WHERE
1432: u1.group_id = r.group_id
1433: AND u2.group_id = r.related_group_id
1434: AND u1.usage='SF_PLANNING'

Line 1470: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,

1466: CURSOR mo_grp_mgr IS
1467: SELECT NVL(MAX(jrs.salesrep_id),0) manager_srp_id
1468: FROM
1469: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1470: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1471: cn_srp_role_dtls srd
1472: WHERE
1473: jg.group_id = jgm.group_id
1474: and jgm.manager_flag = 'Y'

Line 1496: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,

1492: CURSOR mo_mgr_check IS
1493: SELECT jgm.manager_flag manager_flag
1494: FROM
1495: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1496: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1497: cn_srp_role_dtls srd
1498: WHERE
1499: jg.group_id = jgm.group_id
1500: and jgm.manager_flag = 'Y'

Line 1557: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,

1553: IF p_is_multiorg = 'Y' THEN
1554: OPEN mgr_check_rc FOR SELECT jgm.manager_flag manager_flag
1555: FROM
1556: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1557: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1558: cn_srp_role_dtls srd
1559: WHERE
1560: jg.group_id = jgm.group_id
1561: and jgm.manager_flag = 'Y'

Line 1622: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,

1618: IF p_is_multiorg = 'Y' THEN
1619: OPEN grp_mgr_rc FOR SELECT NVL(MAX(jrs.salesrep_id),0) manager_srp_id
1620: FROM
1621: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1622: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1623: cn_srp_role_dtls srd
1624: WHERE
1625: jg.group_id = jgm.group_id
1626: and jgm.manager_flag = 'Y'

Line 2056: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,

2052: srdd.org_code,trunc(srdd.start_date) start_date, trunc(srdd.end_date) end_date,
2053: jgm.role_name role_name,jgm.group_id group_id
2054: FROM
2055: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2056: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,
2057: cn_srp_role_dtls_v srdd
2058: WHERE
2059: jg.group_id = jgm.group_id
2060: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')

Line 2088: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,

2084: CURSOR mo_mgr_check IS
2085: SELECT jgm.manager_flag manager_flag
2086: FROM
2087: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2088: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
2089: cn_srp_role_dtls srd
2090: WHERE
2091: jg.group_id = jgm.group_id
2092: and jgm.manager_flag = 'Y'

Line 2154: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,

2150: OPEN mgr_check_rc FOR
2151: SELECT jgm.manager_flag manager_flag
2152: FROM
2153: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2154: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
2155: cn_srp_role_dtls srd
2156: WHERE
2157: jg.group_id = jgm.group_id
2158: and jgm.manager_flag = 'Y'

Line 2202: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,

2198: srdd.org_code,trunc(srdd.start_date) start_date, trunc(srdd.end_date) end_date,
2199: jgm.group_id group_id
2200: FROM
2201: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2202: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,
2203: cn_srp_role_dtls_v srdd
2204: WHERE
2205: jg.group_id = jgm.group_id
2206: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')

Line 2315: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,

2311: srdd.org_code,trunc(srdd.start_date) start_date, trunc(srdd.end_date) end_date,
2312: jgm.group_id group_id
2313: FROM
2314: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2315: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,
2316: cn_srp_role_dtls_v srdd
2317: WHERE
2318: jg.group_id = jgm.group_id
2319: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')