APPS.ISC_MAINT_WO_ETL_PKG dependencies on STANDARD

Line 224: AND wdj.JOB_TYPE = 3 /* Non-standard job */

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 */
224: AND wdj.JOB_TYPE = 3 /* Non-standard job */
225: AND nvl(wdj.DATE_CLOSED, sysdate) >= g_global_start_date
226: AND WDJ.WIP_ENTITY_ID = ewod.WIP_ENTITY_ID
227: AND wdj. maintenance_object_type in(2,3) ; /* change as per eam-ib change to cater to assets and rebuilds */
228:

Line 304: WHEN OTHERS then /* added as a part of standard */

300: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
301: retcode := SQLCODE;
302: errbuf := SQLERRM;
303: return;
304: WHEN OTHERS then /* added as a part of standard */
305: return;
306: END;
307:
308: l_stmt_num := 20;

Line 319: when OTHERS then /* added as a part of standard */

315: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
316: retcode := SQLCODE;
317: errbuf := SQLERRM;
318: return;
319: when OTHERS then /* added as a part of standard */
320: return;
321: END;
322:
323:

Line 420: AND wdj.JOB_TYPE = 3 /* Non-standard job */

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 */
421: AND wdj.maintenance_object_source = 1 /* Work Orders created by EAM only */
422: AND nvl(wdj.date_closed, sysdate) >= g_global_start_date
423: AND WDJ.WIP_ENTITY_ID = ewod.WIP_ENTITY_ID
424: and wdj.maintenance_object_type in (2,3) /* change as per eam-ib to include assets and rebuilds */