DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on MFG_LOOKUPS

Line 2854: mfg_lookups mfl

2850: CURSOR cs_severity_in_eam_priority
2851: IS
2852: SELECT 'x'
2853: FROM cs_incident_severities_vl csv,
2854: mfg_lookups mfl
2855: WHERE mfl.lookup_code = csv.incident_severity_id AND
2856: csv.incident_severity_id = p_x_nonroutine_rec.severity_id AND
2857: csv.incident_subtype = 'INC' AND
2858: mfl.lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY' AND