APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on HZ_PARTIES

Line 609: from hz_parties a

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

Line 631: from hz_parties a

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

Line 657: from hz_parties a

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

Line 685: from hz_parties a

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

Line 733: FROM hz_parties hzp, jtf_tty_named_accts na

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: