eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on HZ_RELATIONSHIPS

Line 374: FROM hz_relationships hzr

370: --Check for global ultimate
371: BEGIN
372: SELECT 'Y' INTO l_chk_done FROM DUAL
373: WHERE EXISTS (SELECT 'Y'
374: FROM hz_relationships hzr
375: WHERE hzr.subject_table_name = 'HZ_PARTIES'
376: AND hzr.object_table_name = 'HZ_PARTIES'
377: AND hzr.relationship_type = 'GLOBAL_ULTIMATE'
378: AND hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'

Line 396: FROM hz_relationships hzr

392: --Check for domestic ultimate
393: BEGIN
394: SELECT 'Y' INTO l_chk_done FROM DUAL
395: WHERE EXISTS (SELECT 'Y'
396: FROM hz_relationships hzr
397: WHERE hzr.subject_table_name = 'HZ_PARTIES'
398: AND hzr.object_table_name = 'HZ_PARTIES'
399: AND hzr.relationship_type = 'DOMESTIC_ULTIMATE'
400: AND hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'

Line 1737: from hz_relationships hzr,

1733: -- ALL SUBSIDIARIES OF cl_party_id that is owned by lp_user_resource_id, p_terr_group_id
1734: -- QUERY MODIFIED FOR TERR_GROUP_ACCOUNT_ID IN/OUT
1735: cursor c_subsidiaries(cl_terr_group_account_id number) is
1736: select distinct gao.terr_group_account_id
1737: from hz_relationships hzr,
1738: jtf_tty_named_accts nai,
1739: jtf_tty_terr_grp_accts gai,
1740: jtf_tty_named_accts nao,
1741: jtf_tty_terr_grp_accts gao