APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 470: jtf_tty_named_acct_rsc nar

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

Line 482: jtf_tty_named_acct_rsc nar

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

Line 558: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

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

Line 591: , jtf_tty_named_acct_rsc b

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

Line 618: FROM jtf_tty_named_acct_rsc nar

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

Line 644: FROM jtf_tty_named_acct_rsc nar

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

Line 667: FROM jtf_tty_named_acct_rsc nar

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

Line 699: FROM jtf_tty_named_acct_rsc nar

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

Line 2278: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

2274: and b.terr_group_id = TERR_GROUP.TERR_GROUP_ID
2275: AND EXISTS (
2276: /* Named Account exists with Salesperson with this role */
2277: SELECT NULL
2278: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
2279: WHERE tga.terr_group_account_id = nar.terr_group_account_id
2280: AND tga.terr_group_id = b.terr_group_id
2281: AND nar.rsc_role_code = b.role_code )
2282: AND ROWNUM < 2;