DBA Data[Home] [Help]

APPS.EAM_OP_VALIDATE_PVT dependencies on MFG_LOOKUPS

Line 488: from mfg_lookups

484: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
485:
486: select 1
487: into g_dummy
488: from mfg_lookups
489: where lookup_type = 'BOM_COUNT_POINT_TYPE'
490: and lookup_code = p_eam_op_rec.count_point_type;
491:
492: end if;

Line 526: from mfg_lookups

522: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
523:
524: select 1
525: into g_dummy
526: from mfg_lookups
527: where lookup_type = 'SYS_YES_NO'
528: and lookup_code = p_eam_op_rec.backflush_flag;
529:
530: end if;

Line 566: from mfg_lookups

562:
563: if p_eam_op_rec.shutdown_type is not null then
564: select 1
565: into g_dummy
566: from mfg_lookups
567: where lookup_type = g_shutdown_type
568: and lookup_code = p_eam_op_rec.shutdown_type
569: and enabled_flag = 'Y';
570: end if;