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.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on HZ_RELATIONSHIPS

Line 215: FROM hz_relationships group_membership_rel

211:
212: FUNCTION get_company_info (p_party_id IN NUMBER) RETURN VARCHAR2 IS
213: CURSOR company_membership_c (cp_orig_system_id IN NUMBER) IS
214: SELECT 'HZ_COMPANY:'||group_membership_rel.object_id company_name
215: FROM hz_relationships group_membership_rel
216: WHERE group_membership_rel.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
217: AND group_membership_rel.status= 'A'
218: AND group_membership_rel.start_date <= SYSDATE
219: AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE

Line 249: FROM hz_relationships group_membership_rel

245: FUNCTION get_group_info (p_party_id IN NUMBER) RETURN VARCHAR2 IS
246:
247: CURSOR group_membership_c (cp_orig_system_id IN NUMBER) IS
248: SELECT 'HZ_GROUP:'||group_membership_rel.object_id group_name
249: FROM hz_relationships group_membership_rel
250: WHERE group_membership_rel.RELATIONSHIP_CODE = 'MEMBER_OF'
251: AND group_membership_rel.status= 'A'
252: AND group_membership_rel.start_date <= SYSDATE
253: AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE