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 87: hz_relationships,

83: from
84: fnd_user,
85: hz_parties user_parties,
86: hz_parties company_parties,
87: hz_relationships,
88: hz_code_assignments,
89: pon_auction_headers_all auction
90: where
91: fnd_user.user_id = fnd_global.user_id()

Line 93: and hz_relationships.object_id = company_parties.party_id

89: pon_auction_headers_all auction
90: where
91: fnd_user.user_id = fnd_global.user_id()
92: and fnd_user.person_party_id = user_parties.party_id
93: and hz_relationships.object_id = company_parties.party_id
94: and hz_relationships.subject_id = user_parties.party_id
95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE

Line 94: and hz_relationships.subject_id = user_parties.party_id

90: where
91: fnd_user.user_id = fnd_global.user_id()
92: and fnd_user.person_party_id = user_parties.party_id
93: and hz_relationships.object_id = company_parties.party_id
94: and hz_relationships.subject_id = user_parties.party_id
95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE
98: and hz_relationships.end_date >= SYSDATE

Line 95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'

91: fnd_user.user_id = fnd_global.user_id()
92: and fnd_user.person_party_id = user_parties.party_id
93: and hz_relationships.object_id = company_parties.party_id
94: and hz_relationships.subject_id = user_parties.party_id
95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE
98: and hz_relationships.end_date >= SYSDATE
99: and hz_code_assignments.owner_table_id = company_parties.party_id

Line 96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'

92: and fnd_user.person_party_id = user_parties.party_id
93: and hz_relationships.object_id = company_parties.party_id
94: and hz_relationships.subject_id = user_parties.party_id
95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE
98: and hz_relationships.end_date >= SYSDATE
99: and hz_code_assignments.owner_table_id = company_parties.party_id
100: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'

Line 97: and hz_relationships.start_date <= SYSDATE

93: and hz_relationships.object_id = company_parties.party_id
94: and hz_relationships.subject_id = user_parties.party_id
95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE
98: and hz_relationships.end_date >= SYSDATE
99: and hz_code_assignments.owner_table_id = company_parties.party_id
100: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'
101: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'

Line 98: and hz_relationships.end_date >= SYSDATE

94: and hz_relationships.subject_id = user_parties.party_id
95: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE
98: and hz_relationships.end_date >= SYSDATE
99: and hz_code_assignments.owner_table_id = company_parties.party_id
100: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'
101: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
102: and hz_code_assignments.class_code = 'ENTERPRISE'