DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_ETL_PKG dependencies on WIP_DISCRETE_JOBS

Line 219: WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE , EAM_WORK_ORDER_DETAILS ewod

215: ,g_program_login_id program_login_id
216: ,g_program_application_id program_application_id
217: ,g_request_id request_id
218: From
219: WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE , EAM_WORK_ORDER_DETAILS ewod
220: WHERE
221: WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
222: AND ENTITY_TYPE in (6, 7) /* Maintenance job, Closed maintenance job */
223: AND wdj.maintenance_object_source = 1 /* Work Orders created by EAM only */

Line 416: WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE , eam_work_order_details ewod

412: end instance_id
413: ,ewod.user_defined_Status_id user_Defined_Status_id
414: ,wdj.last_update_date
415: From
416: WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE , eam_work_order_details ewod
417: WHERE
418: WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
419: AND we.ENTITY_TYPE in (6, 7) /* Maintenance job, Closed maintenance job */
420: AND wdj.JOB_TYPE = 3 /* Non-standard job */