[Home] [Help]
606: , b.named_account_id
607: , c.terr_group_account_id
608: , a.duns_number_c
609: from hz_parties a
610: , jtf_tty_named_accts b
611: , jtf_tty_terr_grp_accts c
612: where c.terr_group_id = LP_terr_group_id
613: and b.named_account_id = c.named_account_id
614: and a.party_id = b.party_id
628: , b.named_account_id
629: , c.terr_group_account_id
630: , a.duns_number_c
631: from hz_parties a
632: , jtf_tty_named_accts b
633: , jtf_tty_terr_grp_accts c
634: where c.terr_group_id = LP_terr_group_id
635: and b.named_account_id = c.named_account_id
636: and a.party_id = b.party_id
654: , b.named_account_id
655: , c.terr_group_account_id
656: , a.duns_number_c
657: from hz_parties a
658: , jtf_tty_named_accts b
659: , jtf_tty_terr_grp_accts c
660: where c.terr_group_id = LP_terr_group_id
661: and b.named_account_id = c.named_account_id
662: and a.party_id = b.party_id
682: , b.named_account_id
683: , c.terr_group_account_id
684: , a.duns_number_c
685: from hz_parties a
686: , jtf_tty_named_accts b
687: , jtf_tty_terr_grp_accts c
688: where c.terr_group_id = LP_terr_group_id
689: and b.named_account_id = c.named_account_id
690: and a.party_id = b.party_id
729: CURSOR match_rule3(l_na_id number) IS
730: SELECT -1120 qual_usg_id
731: , '=' comparison_operator
732: , hzp.duns_number_c value1_char
733: FROM hz_parties hzp, jtf_tty_named_accts na
734: where hzp.status = 'A'
735: AND hzp.party_id = na.party_id
736: AND na.named_account_id = l_na_id;
737:
902: SELECT COUNT(*)
903: INTO l_na_count
904: from jtf_tty_terr_groups g
905: , jtf_tty_terr_grp_accts ga
906: , jtf_tty_named_accts a
907: where g.terr_group_id = ga.terr_group_id
908: AND ga.named_account_id = a.named_account_id
909: AND g.terr_group_id = TERR_GROUP.TERR_GROUP_ID
910: AND ROWNUM < 2;