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 88: hz_code_assignments,

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

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

Line 100: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'

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

Line 101: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'

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'
103: and auction.auction_header_id = l_auction_header_id
104: and auction.draft_locked = 'Y'
105: and auction.draft_locked_by_contact_id = user_parties.party_id

Line 102: and hz_code_assignments.class_code = 'ENTERPRISE'

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'
103: and auction.auction_header_id = l_auction_header_id
104: and auction.draft_locked = 'Y'
105: and auction.draft_locked_by_contact_id = user_parties.party_id
106: and auction.trading_partner_id = company_parties.party_id