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.AHL_UA_COMMON_PVT dependencies on AHL_VISITS_B

Line 91: from ahl_visits_b vwp, ahl_unit_config_headers uc

87: vwp.visit_id event_id,
88: G_EVENT_TYPE_VISIT event_type,
89: vwp.start_date_time event_start_time,
90: AHL_VWP_TIMES_PVT.GET_VISIT_END_TIME(vwp.VISIT_ID , FND_API.G_FALSE) event_end_time
91: from ahl_visits_b vwp, ahl_unit_config_headers uc
92: where uc.unit_config_header_id = p_unit_config_id
93: and vwp.item_instance_id = uc.csi_item_instance_id
94: --priyan Bug # 5303188
95: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE')

Line 164: from ahl_visits_b vwp, ahl_unit_config_headers uc

160: vwp.visit_id event_id,
161: G_EVENT_TYPE_VISIT event_type,
162: vwp.start_date_time event_start_time,
163: AHL_VWP_TIMES_PVT.GET_VISIT_END_TIME(vwp.VISIT_ID , FND_API.G_FALSE) event_end_time
164: from ahl_visits_b vwp, ahl_unit_config_headers uc
165: where uc.unit_config_header_id = p_unit_config_id
166: and vwp.item_instance_id = uc.csi_item_instance_id
167: --priyan Bug # 5303188
168: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE')

Line 763: FROM AHL_VISITS_B VB,

759: VB.ATTRIBUTE13,
760: VB.ATTRIBUTE14,
761: VB.ATTRIBUTE15,
762: VB.UNIT_SCHEDULE_ID
763: FROM AHL_VISITS_B VB,
764: AHL_UNIT_CONFIG_HEADERS UC,
765: HR_ALL_ORGANIZATION_UNITS HROU,
766: BOM_DEPARTMENTS BDPT
767: WHERE

Line 1026: FROM AHL_VISITS_B VB,

1022: VB.ATTRIBUTE13,
1023: VB.ATTRIBUTE14,
1024: VB.ATTRIBUTE15,
1025: VB.UNIT_SCHEDULE_ID
1026: FROM AHL_VISITS_B VB,
1027: AHL_UNIT_CONFIG_HEADERS UC,
1028: HR_ALL_ORGANIZATION_UNITS HROU,
1029: BOM_DEPARTMENTS BDPT
1030: WHERE