APPS.AHL_PRD_WORKORDER_PVT dependencies on MFG_LOOKUPS

Line 842: FROM MFG_LOOKUPS

838: ELSIF p_x_prd_workorder_rec.job_priority IS not NULL AND
839: p_x_prd_workorder_rec.job_priority<>FND_API.G_MISS_NUM THEN
840:
841: SELECT COUNT(*) INTO l_ctr
842: FROM MFG_LOOKUPS
843: WHERE lookup_type='WIP_EAM_ACTIVITY_PRIORITY'
844: AND lookup_code=p_x_prd_workorder_rec.job_priority;
845:
846: IF l_ctr=0 THEN

Line 2428: MFG_LOOKUPS RESTYPE

2424:
2425: FROM BOM_DEPARTMENT_RESOURCES BDR,
2426: BOM_RESOURCES BR,
2427: AHL_RESOURCE_MAPPINGS MAP,
2428: MFG_LOOKUPS RESTYPE
2429:
2430: WHERE BDR.resource_id = BR.resource_id
2431: AND BR.resource_id = MAP.bom_resource_id
2432: AND MAP.aso_resource_id = c_aso_resource_id