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_NA_TERRGP dependencies on HZ_PARTIES

Line 62: WHERE hzr.subject_table_name = 'HZ_PARTIES'

58: INTO l_chk_done
59: FROM DUAL
60: WHERE EXISTS ( SELECT 'Y'
61: FROM hz_relationships hzr
62: WHERE hzr.subject_table_name = 'HZ_PARTIES'
63: AND hzr.object_table_name = 'HZ_PARTIES'
64: AND hzr.relationship_type = 'GLOBAL_ULTIMATE'
65: AND hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'
66: AND hzr.status = 'A'

Line 63: AND hzr.object_table_name = 'HZ_PARTIES'

59: FROM DUAL
60: WHERE EXISTS ( SELECT 'Y'
61: FROM hz_relationships hzr
62: WHERE hzr.subject_table_name = 'HZ_PARTIES'
63: AND hzr.object_table_name = 'HZ_PARTIES'
64: AND hzr.relationship_type = 'GLOBAL_ULTIMATE'
65: AND hzr.relationship_code = 'GLOBAL_ULTIMATE_OF'
66: AND hzr.status = 'A'
67: AND SYSDATE BETWEEN hzr.start_date AND NVL(hzr.end_date, SYSDATE)

Line 87: WHERE hzr.subject_table_name = 'HZ_PARTIES'

83: INTO l_chk_done
84: FROM DUAL
85: WHERE EXISTS ( SELECT 'Y'
86: FROM hz_relationships hzr
87: WHERE hzr.subject_table_name = 'HZ_PARTIES'
88: AND hzr.object_table_name = 'HZ_PARTIES'
89: AND hzr.relationship_type = 'DOMESTIC_ULTIMATE'
90: AND hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'
91: AND hzr.status = 'A'

Line 88: AND hzr.object_table_name = 'HZ_PARTIES'

84: FROM DUAL
85: WHERE EXISTS ( SELECT 'Y'
86: FROM hz_relationships hzr
87: WHERE hzr.subject_table_name = 'HZ_PARTIES'
88: AND hzr.object_table_name = 'HZ_PARTIES'
89: AND hzr.relationship_type = 'DOMESTIC_ULTIMATE'
90: AND hzr.relationship_code = 'DOMESTIC_ULTIMATE_OF'
91: AND hzr.status = 'A'
92: AND SYSDATE BETWEEN hzr.start_date AND NVL(hzr.end_date, SYSDATE)

Line 109: hz_parties hzp

105:
106: SELECT lkp.lookup_code
107: INTO l_site_type_code
108: FROM fnd_lookups lkp,
109: hz_parties hzp
110: WHERE lkp.lookup_type = 'JTF_TTY_SITE_TYPE_CODE'
111: AND hzp.hq_branch_ind = lkp.lookup_code
112: AND hzp.party_id = p_party_id;
113:

Line 2834: FROM HZ_PARTIES H3,

2830: H1.postal_code
2831: INTO p_business_name,
2832: p_trade_name,
2833: p_postal_code
2834: FROM HZ_PARTIES H3,
2835: HZ_LOCATIONS H1,
2836: HZ_PARTY_SITES H2
2837: WHERE h3.party_id = h2.party_id
2838: AND h2.location_id = h1.location_id