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_DISCRETE_JOBS

Line 825: FROM wip_discrete_jobs di

821: di.status_type lookup_code,
822: di.organization_id organization_id,
823: di.SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE,
824: 1 line_type
825: FROM wip_discrete_jobs di
826: WHERE di.job_type = 1 AND -- only standard jobs
827: di.status_type in (3,4,5,6,7,12,14,15) AND
828: --di.scheduled_start_date >= g_global_start_date
829: di.date_released >= g_global_start_date

Line 1167: FROM WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI, MFG_LOOKUPS ML1

1163: DI.LAST_UPDATE_DATE,
1164: EN.WIP_ENTITY_NAME JOB_NAME,
1165: 1 line_type,
1166: DI.SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
1167: FROM WIP_ENTITIES EN, WIP_DISCRETE_JOBS DI, MFG_LOOKUPS ML1
1168: WHERE
1169: DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND DI.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
1170: DI.JOB_TYPE = 1 AND -- Only Standard Jobs
1171: EN.ENTITY_TYPE IN (1,3,5,8) AND -- Discrete jobs and Closed discrete jobs