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.ENG_CHANGE_ROUTE_PEOPLE_UTIL dependencies on HZ_PARTIES

Line 180: , HZ_PARTIES Company

176: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
177: , Company.PARTY_NAME ASSIGNEE_COMPANY
178: FROM FND_LOOKUPS AssigneeTypeLookup
179: , HZ_RELATIONSHIPS Emp_Cmpy
180: , HZ_PARTIES Company
181: , HZ_PARTIES Parties
182: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'PERSON'
183: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
184: AND Emp_Cmpy.SUBJECT_TYPE (+)= 'PERSON'

Line 181: , HZ_PARTIES Parties

177: , Company.PARTY_NAME ASSIGNEE_COMPANY
178: FROM FND_LOOKUPS AssigneeTypeLookup
179: , HZ_RELATIONSHIPS Emp_Cmpy
180: , HZ_PARTIES Company
181: , HZ_PARTIES Parties
182: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'PERSON'
183: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
184: AND Emp_Cmpy.SUBJECT_TYPE (+)= 'PERSON'
185: AND Emp_Cmpy.SUBJECT_TABLE_NAME (+)= 'HZ_PARTIES'

Line 185: AND Emp_Cmpy.SUBJECT_TABLE_NAME (+)= 'HZ_PARTIES'

181: , HZ_PARTIES Parties
182: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'PERSON'
183: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
184: AND Emp_Cmpy.SUBJECT_TYPE (+)= 'PERSON'
185: AND Emp_Cmpy.SUBJECT_TABLE_NAME (+)= 'HZ_PARTIES'
186: AND Emp_Cmpy.OBJECT_TYPE (+)= 'ORGANIZATION'
187: AND Emp_Cmpy.RELATIONSHIP_CODE (+)= 'EMPLOYEE_OF'
188: AND Emp_Cmpy.OBJECT_TABLE_NAME (+)= 'HZ_PARTIES'
189: AND Emp_Cmpy.STATUS (+)= 'A'

Line 188: AND Emp_Cmpy.OBJECT_TABLE_NAME (+)= 'HZ_PARTIES'

184: AND Emp_Cmpy.SUBJECT_TYPE (+)= 'PERSON'
185: AND Emp_Cmpy.SUBJECT_TABLE_NAME (+)= 'HZ_PARTIES'
186: AND Emp_Cmpy.OBJECT_TYPE (+)= 'ORGANIZATION'
187: AND Emp_Cmpy.RELATIONSHIP_CODE (+)= 'EMPLOYEE_OF'
188: AND Emp_Cmpy.OBJECT_TABLE_NAME (+)= 'HZ_PARTIES'
189: AND Emp_Cmpy.STATUS (+)= 'A'
190: AND Emp_Cmpy.START_DATE (+)<= SYSDATE
191: AND (Emp_Cmpy.END_DATE IS NULL OR Emp_Cmpy.END_DATE >= SYSDATE)
192: AND Company.PARTY_ID (+)= Emp_Cmpy.OBJECT_ID

Line 204: , HZ_PARTIES Grp

200: SELECT Grp.PARTY_NAME ASSIGNEE_NAME
201: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
202: , '' ASSIGNEE_COMPANY
203: FROM FND_LOOKUPS AssigneeTypeLookup
204: , HZ_PARTIES Grp
205: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'GROUP'
206: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
207: AND Grp.PARTY_TYPE = 'GROUP'
208: AND Grp.PARTY_ID = p_group_id ;