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.OPI_DBI_JOBS_PKG dependencies on WIP_REPETITIVE_SCHEDULES

Line 843: FROM wip_repetitive_schedules re

839: re.status_type lookup_code,
840: re.organization_id organization_id,
841: re.last_unit_completion_date SCHEDULED_COMPLETION_DATE,
842: 1 line_type
843: FROM wip_repetitive_schedules re
844: WHERE re.status_type in (3,4,5,6,7,12,14,15) AND
845: --re.first_unit_start_date >= g_global_start_date
846: re.date_released >= g_global_start_date
847: UNION ALL

Line 1192: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE, MFG_LOOKUPS ML1

1188: to_char(RE.REPETITIVE_SCHEDULE_ID) JOB_NAME,
1189: 1 line_type,
1190: RE.last_unit_completion_date SCHEDULED_COMPLETION_DATE
1191: FROM
1192: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE, MFG_LOOKUPS ML1
1193: WHERE
1194: RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
1195: EN.ENTITY_TYPE = 2 AND -- Repetitive Schedules
1196: ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND ML1.LOOKUP_CODE = RE.STATUS_TYPE AND