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_CODE_ASSIGNMENTS

Line 103: hz_code_assignments,

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()
107: and fnd_user.person_party_id = user_parties.party_id

Line 114: and hz_code_assignments.owner_table_id = company_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'
118: and auction.auction_header_id = l_auction_header_id

Line 115: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'

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'
118: and auction.auction_header_id = l_auction_header_id
119: and auction.draft_locked = 'Y'

Line 116: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'

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'
118: and auction.auction_header_id = l_auction_header_id
119: and auction.draft_locked = 'Y'
120: and auction.draft_locked_by_contact_id = user_parties.party_id

Line 117: and hz_code_assignments.class_code = 'ENTERPRISE'

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'
118: and auction.auction_header_id = l_auction_header_id
119: and auction.draft_locked = 'Y'
120: and auction.draft_locked_by_contact_id = user_parties.party_id
121: and auction.trading_partner_id = company_parties.party_id