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