APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on HZ_PARTIES

Line 607: from hz_parties a

603: SELECT substr(a.party_name, 1, 45) || ': ' || a.postal_code name
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

Line 629: from hz_parties a

625: SELECT substr(a.party_name, 1, 45) || ': ' || a.postal_code name
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

Line 655: from hz_parties a

651: SELECT substr(a.party_name, 1, 45) || ': ' || a.postal_code name
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

Line 683: from hz_parties a

679: SELECT substr(a.party_name, 1, 45) || ': ' || a.postal_code name
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

Line 731: FROM hz_parties hzp, jtf_tty_named_accts na

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: