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_AUCTION_INTERFACE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 206: hz_code_assignments

202: FROM fnd_user,
203: hz_parties user_parties,
204: hz_parties company_parties,
205: hz_relationships,
206: hz_code_assignments
207: WHERE fnd_user.person_party_id = user_parties.party_id
208: AND fnd_user.user_id = p_buyer_id
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id

Line 215: AND hz_code_assignments.owner_table_id = company_parties.party_id

211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'
213: AND hz_relationships.start_date <= SYSDATE
214: AND hz_relationships.end_date >= SYSDATE
215: AND hz_code_assignments.owner_table_id = company_parties.party_id
216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'
217: AND hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
218: AND hz_code_assignments.class_code = 'ENTERPRISE';
219:

Line 216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'

212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'
213: AND hz_relationships.start_date <= SYSDATE
214: AND hz_relationships.end_date >= SYSDATE
215: AND hz_code_assignments.owner_table_id = company_parties.party_id
216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'
217: AND hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
218: AND hz_code_assignments.class_code = 'ENTERPRISE';
219:
220: logme(l_log_module, 'current user '||i_draft_locked_by|| 'user contact '||i_draft_locked_by_contact_id);

Line 217: AND hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'

213: AND hz_relationships.start_date <= SYSDATE
214: AND hz_relationships.end_date >= SYSDATE
215: AND hz_code_assignments.owner_table_id = company_parties.party_id
216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'
217: AND hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
218: AND hz_code_assignments.class_code = 'ENTERPRISE';
219:
220: logme(l_log_module, 'current user '||i_draft_locked_by|| 'user contact '||i_draft_locked_by_contact_id);
221: IF l_draft_locked_by <> i_draft_locked_by OR l_draft_locked_by_contact_id <> i_draft_locked_by_contact_id THEN

Line 218: AND hz_code_assignments.class_code = 'ENTERPRISE';

214: AND hz_relationships.end_date >= SYSDATE
215: AND hz_code_assignments.owner_table_id = company_parties.party_id
216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'
217: AND hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
218: AND hz_code_assignments.class_code = 'ENTERPRISE';
219:
220: logme(l_log_module, 'current user '||i_draft_locked_by|| 'user contact '||i_draft_locked_by_contact_id);
221: IF l_draft_locked_by <> i_draft_locked_by OR l_draft_locked_by_contact_id <> i_draft_locked_by_contact_id THEN
222: --Unlock the document if it locked by a different user.