APPS.WIP_JSI_VALIDATOR dependencies on MFG_LOOKUPS

Line 2523: from mfg_lookups

2519: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2520: wjsi_row.shutdown_type is not null) then
2521: select 1
2522: into g_dummy
2523: from mfg_lookups
2524: where lookup_type = 'BOM_EAM_SHUTDOWN_TYPE'
2525: and lookup_code = wjsi_row.shutdown_type
2526: and enabled_flag = 'Y';
2527: end if;

Line 2560: from mfg_lookups

2556: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2557: wjsi_row.work_order_type is not null) then
2558: select 1
2559: into g_dummy
2560: from mfg_lookups
2561: where lookup_type = 'WIP_EAM_WORK_ORDER_TYPE'
2562: and lookup_code = wjsi_row.work_order_type
2563: and enabled_flag = 'Y';
2564: end if;

Line 2575: from mfg_lookups

2571: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2572: wjsi_row.activity_type is not null) then
2573: select 1
2574: into g_dummy
2575: from mfg_lookups
2576: where lookup_type = 'MTL_EAM_ACTIVITY_TYPE'
2577: and lookup_code = wjsi_row.activity_type
2578: and enabled_flag = 'Y';
2579: end if;

Line 2590: from mfg_lookups

2586: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job,
2587: wip_constants.resched_job) and wjsi_row.activity_cause is not null) then
2588: select 1
2589: into g_dummy
2590: from mfg_lookups
2591: where lookup_type = 'MTL_EAM_ACTIVITY_CAUSE'
2592: and lookup_code = wjsi_row.activity_cause
2593: and enabled_flag = 'Y';
2594: end if;

Line 2639: from mfg_lookups

2635: raise fnd_api.g_exc_unexpected_error;
2636: else
2637: select 1
2638: into g_dummy
2639: from mfg_lookups
2640: where lookup_type = 'WIP_MAINTENANCE_OBJECT_SOURCE'
2641: and lookup_code = wjsi_row.maintenance_object_source
2642: and enabled_flag = 'Y';
2643: end if;

Line 2706: from mfg_lookups

2702: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2703: wjsi_row.activity_source is not null) then
2704: select 1
2705: into g_dummy
2706: from mfg_lookups
2707: where lookup_type = 'MTL_EAM_ACTIVITY_SOURCE'
2708: and lookup_code = wjsi_row.activity_source
2709: and enabled_flag = 'Y';
2710: end if;