APPS.WIP_JSI_VALIDATOR dependencies on MFG_LOOKUPS

Line 2528: from mfg_lookups

2524: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2525: wjsi_row.shutdown_type is not null) then
2526: select 1
2527: into g_dummy
2528: from mfg_lookups
2529: where lookup_type = 'BOM_EAM_SHUTDOWN_TYPE'
2530: and lookup_code = wjsi_row.shutdown_type
2531: and enabled_flag = 'Y';
2532: end if;

Line 2565: from mfg_lookups

2561: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2562: wjsi_row.work_order_type is not null) then
2563: select 1
2564: into g_dummy
2565: from mfg_lookups
2566: where lookup_type = 'WIP_EAM_WORK_ORDER_TYPE'
2567: and lookup_code = wjsi_row.work_order_type
2568: and enabled_flag = 'Y';
2569: end if;

Line 2580: from mfg_lookups

2576: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2577: wjsi_row.activity_type is not null) then
2578: select 1
2579: into g_dummy
2580: from mfg_lookups
2581: where lookup_type = 'MTL_EAM_ACTIVITY_TYPE'
2582: and lookup_code = wjsi_row.activity_type
2583: and enabled_flag = 'Y';
2584: end if;

Line 2595: from mfg_lookups

2591: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job,
2592: wip_constants.resched_job) and wjsi_row.activity_cause is not null) then
2593: select 1
2594: into g_dummy
2595: from mfg_lookups
2596: where lookup_type = 'MTL_EAM_ACTIVITY_CAUSE'
2597: and lookup_code = wjsi_row.activity_cause
2598: and enabled_flag = 'Y';
2599: end if;

Line 2644: from mfg_lookups

2640: raise fnd_api.g_exc_unexpected_error;
2641: else
2642: select 1
2643: into g_dummy
2644: from mfg_lookups
2645: where lookup_type = 'WIP_MAINTENANCE_OBJECT_SOURCE'
2646: and lookup_code = wjsi_row.maintenance_object_source
2647: and enabled_flag = 'Y';
2648: end if;

Line 2711: from mfg_lookups

2707: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2708: wjsi_row.activity_source is not null) then
2709: select 1
2710: into g_dummy
2711: from mfg_lookups
2712: where lookup_type = 'MTL_EAM_ACTIVITY_SOURCE'
2713: and lookup_code = wjsi_row.activity_source
2714: and enabled_flag = 'Y';
2715: end if;