APPS.JTF_TTY_GEN_TERR_PVT dependencies on HZ_PARTIES

Line 4507: FROM hz_parties a

4503: , b.named_account_id
4504: , c.terr_group_account_id
4505: , c.start_date
4506: , c.end_date
4507: FROM hz_parties a
4508: , jtf_tty_named_accts b
4509: , jtf_tty_terr_grp_accts c
4510: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4511: AND b.named_account_id = c.named_account_id

Line 4530: FROM hz_parties a

4526: , c.terr_group_account_id
4527: , a.duns_number_c
4528: , c.start_date
4529: , c.end_date
4530: FROM hz_parties a
4531: , jtf_tty_named_accts b
4532: , jtf_tty_terr_grp_accts c
4533: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4534: AND b.named_account_id = c.named_account_id

Line 4556: FROM hz_parties a

4552: CURSOR get_OVLY_party_info(LP_terr_group_acct_id NUMBER, lp_matching_rule_code VARCHAR2) IS
4553: SELECT SUBSTR(a.party_name, 1, 45) || ': ' || a.postal_code name
4554: , b.named_account_id
4555: , c.terr_group_account_id
4556: FROM hz_parties a
4557: , jtf_tty_named_accts b
4558: , jtf_tty_terr_grp_accts c
4559: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4560: AND b.named_account_id = c.named_account_id

Line 4583: FROM hz_parties a

4579: SELECT SUBSTR(a.party_name, 1, 45) || ': ' || a.postal_code name
4580: , b.named_account_id
4581: , c.terr_group_account_id
4582: , a.duns_number_c
4583: FROM hz_parties a
4584: , jtf_tty_named_accts b
4585: , jtf_tty_terr_grp_accts c
4586: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4587: AND b.named_account_id = c.named_account_id

Line 4629: FROM hz_parties hzp, jtf_tty_named_accts na

4625: SELECT DECODE(l_matching_rule_code, '4', -1129, '2', -1120, '3', -1120, '5',-1005, -1001) qual_usg_id
4626: , '=' comparison_operator
4627: , DECODE(l_matching_rule_code, '4', hzp.party_number, '2', hzp.duns_number_c, '3', hzp.duns_number_c) value1_char
4628: , DECODE(l_matching_rule_code, '5', na.party_site_id, hzp.party_id) value1_num
4629: FROM hz_parties hzp, jtf_tty_named_accts na
4630: WHERE hzp.status = 'A'
4631: AND hzp.party_id = na.party_id
4632: AND na.named_account_id = l_na_id;
4633:

Line 7225: FROM hz_parties a

7221: , c.attribute12
7222: , c.attribute13
7223: , c.attribute14
7224: , c.attribute15
7225: FROM hz_parties a
7226: , jtf_tty_named_accts b
7227: , jtf_tty_terr_grp_accts c
7228: WHERE c.terr_group_id = LP_terr_group_id
7229: AND b.named_account_id = c.named_account_id

Line 7264: FROM hz_parties a

7260: , c.attribute12
7261: , c.attribute13
7262: , c.attribute14
7263: , c.attribute15
7264: FROM hz_parties a
7265: , jtf_tty_named_accts b
7266: , jtf_tty_terr_grp_accts c
7267: WHERE c.terr_group_id = LP_terr_group_id
7268: AND b.named_account_id = c.named_account_id

Line 7303: FROM hz_parties a

7299: , c.attribute12
7300: , c.attribute13
7301: , c.attribute14
7302: , c.attribute15
7303: FROM hz_parties a
7304: , jtf_tty_named_accts b
7305: , jtf_tty_terr_grp_accts c
7306: WHERE c.terr_group_id = LP_terr_group_id
7307: AND b.named_account_id = c.named_account_id

Line 7346: FROM hz_parties a

7342: , c.attribute12
7343: , c.attribute13
7344: , c.attribute14
7345: , c.attribute15
7346: FROM hz_parties a
7347: , jtf_tty_named_accts b
7348: , jtf_tty_terr_grp_accts c
7349: WHERE c.terr_group_id = LP_terr_group_id
7350: AND b.named_account_id = c.named_account_id

Line 7393: FROM hz_parties hzp, jtf_tty_named_accts na

7389: SELECT DECODE(l_matching_rule_code, '4', -1129, '2', -1120, '3', -1120, '5',-1005, -1001) qual_usg_id
7390: , '=' comparison_operator
7391: , DECODE(l_matching_rule_code, '4', hzp.party_number, '2', hzp.duns_number_c, '3', hzp.duns_number_c) value1_char
7392: , DECODE(l_matching_rule_code, '5', na.party_site_id, hzp.party_id) value1_num
7393: FROM hz_parties hzp, jtf_tty_named_accts na
7394: WHERE hzp.status = 'A'
7395: AND hzp.party_id = na.party_id
7396: AND na.named_account_id = l_na_id;
7397: