DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on MFG_LOOKUPS

Line 111: FROM MFG_LOOKUPS

107:
108: /* Validate object_typ and source_typ */
109: SELECT COUNT(1)
110: INTO l_valid_object_type
111: FROM MFG_LOOKUPS
112: WHERE lookup_type = 'EAM_ASSET_FAIL_SRC_TYPE'
113: AND lookup_code = l_eam_failure_entry_record.source_type;
114:
115: IF l_valid_object_type = 0 THEN

Line 125: FROM MFG_LOOKUPS

121: END IF;
122:
123: SELECT COUNT(1)
124: INTO l_valid_object_type
125: FROM MFG_LOOKUPS
126: WHERE lookup_type = 'WIP_MAINTENANCE_OBJECT_TYPE'
127: AND lookup_code = l_eam_failure_entry_record.object_type;
128:
129: IF l_valid_object_type = 0 THEN