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

Line 102: hz_relationships,

98: from
99: fnd_user,
100: hz_parties user_parties,
101: hz_parties company_parties,
102: hz_relationships,
103: hz_code_assignments,
104: pon_auction_headers_all auction
105: where
106: fnd_user.user_id = fnd_global.user_id()

Line 108: and hz_relationships.object_id = company_parties.party_id

104: pon_auction_headers_all auction
105: where
106: fnd_user.user_id = fnd_global.user_id()
107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
112: and hz_relationships.start_date <= SYSDATE

Line 109: and hz_relationships.subject_id = user_parties.party_id

105: where
106: fnd_user.user_id = fnd_global.user_id()
107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
112: and hz_relationships.start_date <= SYSDATE
113: and hz_relationships.end_date >= SYSDATE

Line 110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'

106: fnd_user.user_id = fnd_global.user_id()
107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
112: and hz_relationships.start_date <= SYSDATE
113: and hz_relationships.end_date >= SYSDATE
114: and hz_code_assignments.owner_table_id = company_parties.party_id

Line 111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'

107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
112: and hz_relationships.start_date <= SYSDATE
113: and hz_relationships.end_date >= SYSDATE
114: and hz_code_assignments.owner_table_id = company_parties.party_id
115: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'

Line 112: and hz_relationships.start_date <= SYSDATE

108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
112: and hz_relationships.start_date <= SYSDATE
113: and hz_relationships.end_date >= SYSDATE
114: and hz_code_assignments.owner_table_id = company_parties.party_id
115: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'
116: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'

Line 113: and hz_relationships.end_date >= SYSDATE

109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
112: and hz_relationships.start_date <= SYSDATE
113: and hz_relationships.end_date >= SYSDATE
114: and hz_code_assignments.owner_table_id = company_parties.party_id
115: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'
116: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
117: and hz_code_assignments.class_code = 'ENTERPRISE'