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_TCA_MERGE_PVT dependencies on HZ_RELATIONSHIPS

Line 175: HZ_RELATIONSHIPS,

171: IS
172: SELECT 'BUYER' AS USER_TYPE
173: FROM
174: HZ_PARTIES USER_PARTIES,
175: HZ_RELATIONSHIPS,
176: HZ_CODE_ASSIGNMENTS
177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

Line 178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID

174: HZ_PARTIES USER_PARTIES,
175: HZ_RELATIONSHIPS,
176: HZ_CODE_ASSIGNMENTS
177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE

Line 179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'

175: HZ_RELATIONSHIPS,
176: HZ_CODE_ASSIGNMENTS
177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID

Line 180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

176: HZ_CODE_ASSIGNMENTS
177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE

177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'

Line 182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE

178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'

Line 183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID

179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
187: UNION