APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 472: jtf_tty_named_acct_rsc nar

468: */
469: CURSOR get_NON_OVLY_na_trans(LP_terr_group_account_id NUMBER) IS
470: SELECT ra.access_type
471: FROM
472: jtf_tty_named_acct_rsc nar
473: , jtf_tty_terr_grp_accts tga
474: , jtf_tty_terr_grp_roles tgr
475: , jtf_tty_role_access ra
476: WHERE tga.terr_group_account_id = nar.terr_group_account_id

Line 484: jtf_tty_named_acct_rsc nar

480: AND ra.access_type IN ('ACCOUNT')
481: UNION
482: SELECT ra.access_type
483: FROM
484: jtf_tty_named_acct_rsc nar
485: , jtf_tty_terr_grp_accts tga
486: , jtf_tty_terr_grp_roles tgr
487: , jtf_tty_role_access ra
488: WHERE tga.terr_group_account_id = nar.terr_group_account_id

Line 560: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

556: and b.terr_group_id = lp_terr_group_id
557: AND EXISTS (
558: /* Named Account exists with Salesperson with this role */
559: SELECT NULL
560: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
561: WHERE tga.terr_group_account_id = nar.terr_group_account_id
562: AND nar.terr_group_account_id = lp_terr_group_account_id
563: AND tga.terr_group_id = b.terr_group_id
564: AND nar.rsc_role_code = b.role_code );

Line 593: , jtf_tty_named_acct_rsc b

589: SELECT distinct b.resource_id
590: , b.rsc_group_id
591: , b.rsc_resource_type
592: from jtf_tty_terr_grp_accts a
593: , jtf_tty_named_acct_rsc b
594: where a.terr_group_account_id = l_terr_group_acct_id
595: and a.terr_group_account_id = b.terr_group_account_id
596: and b.rsc_role_code = l_role;
597:

Line 620: FROM jtf_tty_named_acct_rsc nar

616: AND a.DUNS_NUMBER_C IS NOT NULL
617: AND EXISTS (
618: /* Salesperson exists for this Named Account */
619: SELECT NULL
620: FROM jtf_tty_named_acct_rsc nar
621: WHERE nar.terr_group_account_id = C.TERR_GROUP_ACCOUNT_ID );
622:
623:
624: /* get the PARTY_NAME + POSTAL_CODE for the Named Account:

Line 646: FROM jtf_tty_named_acct_rsc nar

642: where d.named_account_id = c.named_account_id )
643: AND EXISTS (
644: /* Salesperson exists for this Named Account */
645: SELECT NULL
646: FROM jtf_tty_named_acct_rsc nar
647: WHERE nar.terr_group_account_id = C.TERR_GROUP_ACCOUNT_ID );
648:
649:
650: /* get the DUNS# for the Named Account:

Line 669: FROM jtf_tty_named_acct_rsc nar

665: AND EXISTS (
666: /* Salesperson, with Role that has a Product
667: ** Interest defined, exists for this Named Account */
668: SELECT NULL
669: FROM jtf_tty_named_acct_rsc nar
670: , jtf_tty_role_prod_int rpi
671: , jtf_tty_terr_grp_roles tgr
672: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
673: AND tgr.terr_group_id = C.TERR_GROUP_ID

Line 701: FROM jtf_tty_named_acct_rsc nar

697: AND EXISTS (
698: /* Salesperson, with Role that has a Product
699: ** Interest defined, exists for this Named Account */
700: SELECT NULL
701: FROM jtf_tty_named_acct_rsc nar
702: , jtf_tty_role_prod_int rpi
703: , jtf_tty_terr_grp_roles tgr
704: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
705: AND tgr.terr_group_id = C.TERR_GROUP_ID

Line 2267: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

2263: and b.terr_group_id = TERR_GROUP.TERR_GROUP_ID
2264: AND EXISTS (
2265: /* Named Account exists with Salesperson with this role */
2266: SELECT NULL
2267: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
2268: WHERE tga.terr_group_account_id = nar.terr_group_account_id
2269: AND tga.terr_group_id = b.terr_group_id
2270: AND nar.rsc_role_code = b.role_code )
2271: AND ROWNUM < 2;