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.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 244: DELETE from jtf_tty_named_acct_rsc j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);

240: END IF;
241:
242: -- Delete Named Account Resources
243: FORALL idx in l_grpAcctId_tbl.FIRST .. l_grpAcctId_tbl.LAST
244: DELETE from jtf_tty_named_acct_rsc j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);
245:
246: -- Delete Terr Group Accounts
247: FORALL idx in l_grpAcctId_tbl.FIRST .. l_grpAcctId_tbl.LAST
248: DELETE from JTF_TTY_TERR_GRP_ACCTS j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);

Line 392: DELETE FROM jtf_tty_named_acct_rsc j

388: group by narsc.RESOURCE_ID, narsc.RSC_GROUP_ID, na.site_type_code)ilv);
389: */
390: /* delete the existing assignments */
391:
392: DELETE FROM jtf_tty_named_acct_rsc j
393: WHERE j.TERR_GROUP_ACCOUNT_ID IN
394: (SELECT TERR_GROUP_ACCOUNT_ID
395: FROM JTF_TTY_TERR_GRP_ACCTS
396: WHERE TERR_GROUP_ID = p_terr_gp_id);

Line 522: FROM JTF_TTY_NAMED_ACCT_RSC NAR,

518: IS
519: SELECT tga.terr_group_account_id tga_id,
520: NAR.assigned_flag aflag,
521: tgo.rsc_group_id parentgrpid
522: FROM JTF_TTY_NAMED_ACCT_RSC NAR,
523: JTF_TTY_TERR_GRP_ACCTS TGA,
524: jtf_tty_terr_grp_owners tgo,
525: jtf_rs_groups_denorm gd
526: WHERE NAR.terr_group_account_id = TGA.terr_group_account_id

Line 544: FROM JTF_TTY_NAMED_ACCT_RSC NAR,

540: CURSOR NAHasNoOwnerAsParent
541: IS
542: SELECT tga.terr_group_account_id tga_id,
543: NAR.rsc_group_id currentgrpid
544: FROM JTF_TTY_NAMED_ACCT_RSC NAR,
545: JTF_TTY_TERR_GRP_ACCTS TGA
546: WHERE NAR.terr_group_account_id = TGA.terr_group_account_id
547: AND TGA.TERR_GROUP_ID = p_terr_gp_id
548: AND NAR.rsc_resource_type = 'RS_EMPLOYEE'

Line 698: FROM jtf_tty_named_acct_rsc narsc,

694: WHILE (FOUND=0 AND indx<= NewCandidateGrp.COUNT)
695: LOOP
696: BEGIN
697: SELECT 'Y' INTO result
698: FROM jtf_tty_named_acct_rsc narsc,
699: jtf_tty_terr_grp_accts tga,
700: jtf_rs_role_relations rlt ,
701: jtf_rs_group_members grpmem ,
702: jtf_rs_groups_denorm grpdn

Line 841: UPDATE jtf_tty_named_acct_rsc narsc

837: /*update all account assignments that are owned by deleted manager
838: id ( by resource_id and group_id ) and assigned_flag = 'N'
839: with replaced owner */
840:
841: UPDATE jtf_tty_named_acct_rsc narsc
842: SET resource_id = RplOwnerToRsc(idx),
843: rsc_group_id = RplOwnerToGrp(idx),
844: rsc_role_code = RplOwnerToRole(idx)
845: WHERE narsc.resource_id = RplOwnerFromRsc(idx)

Line 860: DELETE FROM jtf_tty_named_acct_rsc narsc

856: terr_grp_id := mytabletype();
857: terrgrpid_nodup := mytabletype();
858:
859: -- SOLIN, bug4943336, performance tuning
860: DELETE FROM jtf_tty_named_acct_rsc narsc
861: WHERE narsc.terr_group_account_id
862: IN ( SELECT terr_group_account_id
863: FROM jtf_tty_terr_grp_accts,
864: jtf_rs_role_relations rlt ,

Line 916: INSERT INTO jtf_tty_named_acct_rsc(

912: END IF;
913:
914: IF terrgrpid_nodup.COUNT>0 THEN
915: FORALL i IN terrgrpid_nodup.FIRST .. terrgrpid_nodup.LAST
916: INSERT INTO jtf_tty_named_acct_rsc(
917: ACCOUNT_RESOURCE_ID,
918: OBJECT_VERSION_NUMBER,
919: TERR_GROUP_ACCOUNT_ID,
920: RESOURCE_ID,

Line 929: ( SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,

925: CREATED_BY,
926: CREATION_DATE,
927: LAST_UPDATED_BY,
928: LAST_UPDATE_DATE)
929: ( SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,
930: 1,
931: terrgrpid_nodup(i),
932: RplOwnerToRsc(idx),
933: RplOwnerToGrp(idx),

Line 961: DELETE from jtf_tty_named_acct_rsc j

957:
958: -- If the assign_flag='Y' check validation, if 'N', this NA should be assigned to new TG owner who is qualified as a parent IF tgaHasParent.aflag='N' THEN
959:
960:
961: DELETE from jtf_tty_named_acct_rsc j
962: WHERE j.TERR_GROUP_ACCOUNT_ID = tgaHasParent.tga_id;
963: --and ...;
964:
965: FOR owner IN TGOwner

Line 969: INSERT INTO jtf_tty_named_acct_rsc(

965: FOR owner IN TGOwner
966: LOOP
967:
968: --create assignment
969: INSERT INTO jtf_tty_named_acct_rsc(
970: ACCOUNT_RESOURCE_ID,
971: OBJECT_VERSION_NUMBER,
972: TERR_GROUP_ACCOUNT_ID,
973: RESOURCE_ID,

Line 982: ( SELECT jtf_tty_named_acct_rsc_s.nextval,

978: CREATED_BY,
979: CREATION_DATE,
980: LAST_UPDATED_BY,
981: LAST_UPDATE_DATE)
982: ( SELECT jtf_tty_named_acct_rsc_s.nextval,
983: 1,
984: tgaHasParent.tga_id,
985: owner.resource_id,
986: owner.rsc_group_id,

Line 997: FROM jtf_tty_named_acct_rsc r

993: sysdate
994: FROM dual
995: WHERE NOT EXISTS
996: ( SELECT NULL
997: FROM jtf_tty_named_acct_rsc r
998: WHERE r.TERR_GROUP_ACCOUNT_ID = tgaHasParent.tga_id
999: AND r.RESOURCE_ID = owner.resource_id
1000: AND r.RSC_ROLE_CODE = owner.rsc_role_code
1001: AND r.RSC_GROUP_ID = owner.rsc_group_id

Line 1026: INSERT INTO jtf_tty_named_acct_rsc(

1022: FOR owner IN TGOwner
1023: LOOP
1024:
1025: -- create assignment
1026: INSERT INTO jtf_tty_named_acct_rsc(
1027: ACCOUNT_RESOURCE_ID,
1028: OBJECT_VERSION_NUMBER,
1029: TERR_GROUP_ACCOUNT_ID,
1030: RESOURCE_ID,

Line 1039: ( SELECT jtf_tty_named_acct_rsc_s.nextval,

1035: CREATED_BY,
1036: CREATION_DATE,
1037: LAST_UPDATED_BY,
1038: LAST_UPDATE_DATE)
1039: ( SELECT jtf_tty_named_acct_rsc_s.nextval,
1040: 1,
1041: tgaNoParent.tga_id,
1042: owner.resource_id,
1043: owner.rsc_group_id,

Line 1054: FROM jtf_tty_named_acct_rsc r

1050: sysdate
1051: FROM dual
1052: WHERE NOT EXISTS
1053: ( SELECT NULL
1054: FROM jtf_tty_named_acct_rsc r
1055: WHERE r.TERR_GROUP_ACCOUNT_ID = tgaNoParent.tga_id
1056: AND r.RESOURCE_ID = owner.resource_id
1057: AND r.RSC_ROLE_CODE = owner.rsc_role_code
1058: AND r.RSC_GROUP_ID = owner.rsc_group_id

Line 1190: DELETE from jtf_tty_named_acct_rsc j

1186:
1187: /* commented out by shli
1188: for group_data in groups_managed_c loop
1189: managed_group_id := group_data.group_id;
1190: DELETE from jtf_tty_named_acct_rsc j
1191: WHERE j.TERR_GROUP_ACCOUNT_ID in
1192: (SELECT TERR_GROUP_ACCOUNT_ID
1193: FROM JTF_TTY_TERR_GRP_ACCTS
1194: WHERE TERR_GROUP_ID = p_terr_gp_id)

Line 1263: DELETE from jtf_tty_named_acct_rsc j

1259: */
1260: /* commented out by shli
1261: for child_gp_data in child_groups_c loop
1262: child_group_id := child_gp_data.group_id;
1263: DELETE from jtf_tty_named_acct_rsc j
1264: WHERE j.TERR_GROUP_ACCOUNT_ID in
1265: (SELECT TERR_GROUP_ACCOUNT_ID
1266: FROM JTF_TTY_TERR_GRP_ACCTS
1267: WHERE TERR_GROUP_ID = p_terr_gp_id)

Line 1348: INSERT INTO jtf_tty_named_acct_rsc(

1344: AS
1345: BEGIN
1346:
1347:
1348: INSERT INTO jtf_tty_named_acct_rsc(
1349: ACCOUNT_RESOURCE_ID,
1350: OBJECT_VERSION_NUMBER,
1351: TERR_GROUP_ACCOUNT_ID,
1352: RESOURCE_ID,

Line 1361: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,

1357: CREATED_BY,
1358: CREATION_DATE,
1359: LAST_UPDATED_BY,
1360: LAST_UPDATE_DATE)
1361: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,
1362: 1,
1363: p_terr_gp_acct_id,
1364: p_resource_id,
1365: p_group_id,

Line 1375: ( SELECT NULL FROM jtf_tty_named_acct_rsc r

1371: p_user_id,
1372: SYSDATE
1373: FROM dual
1374: WHERE NOT EXISTS
1375: ( SELECT NULL FROM jtf_tty_named_acct_rsc r
1376: WHERE r.TERR_GROUP_ACCOUNT_ID = p_terr_gp_acct_id
1377: AND r.RESOURCE_ID = p_resource_id
1378: AND r.RSC_ROLE_CODE = p_role_code
1379: AND r.RSC_GROUP_ID = p_group_id

Line 1448: INSERT INTO jtf_tty_named_acct_rsc(

1444: -- 01/15/03: SGKUMAR: Also added if account does not
1445: -- belong to TG and additionally the same owner because a tga
1446: -- can belong to multiple owners
1447:
1448: INSERT INTO jtf_tty_named_acct_rsc(
1449: ACCOUNT_RESOURCE_ID,
1450: OBJECT_VERSION_NUMBER,
1451: TERR_GROUP_ACCOUNT_ID,
1452: RESOURCE_ID,

Line 1461: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,

1457: CREATED_BY,
1458: CREATION_DATE,
1459: LAST_UPDATED_BY,
1460: LAST_UPDATE_DATE)
1461: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,
1462: 1,
1463: a.TERR_GROUP_ACCOUNT_ID,
1464: p_resource_id,
1465: p_group_id,

Line 1476: ( SELECT NULL FROM jtf_tty_named_acct_rsc r

1472: SYSDATE
1473: FROM jtf_tty_terr_grp_accts a, dual
1474: WHERE terr_group_id = p_terr_gp_id
1475: AND NOT EXISTS
1476: ( SELECT NULL FROM jtf_tty_named_acct_rsc r
1477: WHERE r.TERR_GROUP_ACCOUNT_ID = a.TERR_GROUP_ACCOUNT_ID
1478: AND r.RESOURCE_ID = p_resource_id
1479: AND r.RSC_ROLE_CODE = p_role_code
1480: AND r.RSC_GROUP_ID = p_group_id

Line 1493: -- Changed table in NOT EXISTS from jtf_tty_named_acct_rsc

1489: -- Added check (NOT EXISTS) to only INSERT a record
1490: -- if it is a new NA that does not already belong
1491: -- to the TG.
1492: -- 01/08/03: JDOCHERT: FIX FOR BUG#2741455
1493: -- Changed table in NOT EXISTS from jtf_tty_named_acct_rsc
1494: -- to jtf_tty_acct_rsc_dn
1495: --
1496: /*
1497: INSERT into jtf_tty_acct_rsc_dn(

Line 1734: jtf_tty_named_acct_rsc narsc,

1730: FROM
1731: jtf_tty_named_accts na,
1732: jtf_tty_terr_grp_accts ga,
1733: jtf_tty_my_resources_v repdn,
1734: jtf_tty_named_acct_rsc narsc,
1735: jtf_rs_resource_extns rs,
1736: jtf_rs_group_members mem,
1737: jtf_tty_terr_groups ttygrp
1738: WHERE na.named_account_id = ga.named_account_id

Line 1758: jtf_tty_named_acct_rsc narsc,

1754: FROM
1755: jtf_tty_named_accts na,
1756: jtf_tty_terr_grp_accts ga,
1757: jtf_tty_my_resources_v repdn,
1758: jtf_tty_named_acct_rsc narsc,
1759: jtf_rs_resource_extns rs,
1760: jtf_rs_group_members mem,
1761: jtf_tty_terr_groups ttygrp
1762: WHERE na.named_account_id = ga.named_account_id

Line 1801: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,

1797: WHERE lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
1798:
1799: CURSOR salesrep_named_accounts_c
1800: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts
1801: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
1802: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
1803: WHERE na.named_account_id = tga.named_account_id
1804: AND tga.terr_group_id = tg.terr_group_id
1805: AND (tg.active_from_date <= SYSDATE OR tg.active_from_date IS NULL)

Line 1815: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,

1811: AND na.site_type_code = p_site_type_code;
1812:
1813: CURSOR salesrep_named_accounts_all_c
1814: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts
1815: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
1816: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
1817: WHERE na.named_account_id = tga.named_account_id
1818: AND tga.terr_group_id = tg.terr_group_id
1819: AND (tg.active_from_date <= SYSDATE OR tg.active_from_date IS NULL)

Line 2126: from jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,

2122: narsc.RSC_GROUP_ID,
2123: 'RS_EMPLOYEE',
2124: na.site_type_code,
2125: count(na.NAMED_ACCOUNT_ID) num_accts
2126: from jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
2127: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
2128: where na.named_account_id = tga.named_account_id
2129: and tga.terr_group_id = tg.terr_group_id
2130: and (tg.active_from_date <= sysdate or tg.active_from_date is null)

Line 2433: DELETE FROM jtf_tty_named_acct_rsc j

2429: BEGIN
2430: p_user_id := Fnd_Global.user_id;
2431:
2432: /* delete the existing assignments */
2433: DELETE FROM jtf_tty_named_acct_rsc j
2434: WHERE j.TERR_GROUP_ACCOUNT_ID IN
2435: (SELECT TERR_GROUP_ACCOUNT_ID
2436: FROM JTF_TTY_TERR_GRP_ACCTS
2437: WHERE TERR_GROUP_ID = p_terr_gp_id)

Line 2464: DELETE FROM jtf_tty_named_acct_rsc j

2460: sum_res_gp_accts(p_user_id, p_resource_id, p_group_id);
2461: */
2462: FOR group_data IN groups_managed_c LOOP
2463: managed_group_id := group_data.group_id;
2464: DELETE FROM jtf_tty_named_acct_rsc j
2465: WHERE j.TERR_GROUP_ACCOUNT_ID IN
2466: (SELECT TERR_GROUP_ACCOUNT_ID
2467: FROM JTF_TTY_TERR_GRP_ACCTS
2468: WHERE TERR_GROUP_ID = p_terr_gp_id)

Line 2535: DELETE FROM jtf_tty_named_acct_rsc j

2531: group by narsc.RESOURCE_ID, narsc.RSC_GROUP_ID, na.site_type_code)ilv);
2532: */
2533: FOR child_gp_data IN child_groups_c LOOP
2534: child_group_id := child_gp_data.group_id;
2535: DELETE FROM jtf_tty_named_acct_rsc j
2536: WHERE j.TERR_GROUP_ACCOUNT_ID IN
2537: (SELECT TERR_GROUP_ACCOUNT_ID
2538: FROM JTF_TTY_TERR_GRP_ACCTS
2539: WHERE TERR_GROUP_ID = p_terr_gp_id)

Line 2796: DELETE FROM jtf_tty_named_acct_rsc j

2792:
2793: BEGIN
2794:
2795: -- delete assignment for the grp account
2796: DELETE FROM jtf_tty_named_acct_rsc j
2797: WHERE j.TERR_GROUP_ACCOUNT_ID = p_tga_id;
2798:
2799: -- delete grp account
2800: DELETE FROM JTF_TTY_TERR_GRP_ACCTS

Line 3163: SELECT jtf_tty_named_acct_rsc_s.NEXTVAL

3159: );
3160: END IF;
3161: -- assign resource to the named account
3162:
3163: SELECT jtf_tty_named_acct_rsc_s.NEXTVAL
3164: INTO p_terr_gp_acct_rsc_id
3165: FROM dual;
3166:
3167: INSERT INTO jtf_tty_named_acct_rsc

Line 3167: INSERT INTO jtf_tty_named_acct_rsc

3163: SELECT jtf_tty_named_acct_rsc_s.NEXTVAL
3164: INTO p_terr_gp_acct_rsc_id
3165: FROM dual;
3166:
3167: INSERT INTO jtf_tty_named_acct_rsc
3168: (ACCOUNT_RESOURCE_ID,
3169: OBJECT_VERSION_NUMBER ,
3170: TERR_GROUP_ACCOUNT_ID,
3171: RESOURCE_ID ,