APPS.WMS_LMS_UTILS dependencies on MFG_LOOKUPS

Line 1132: select meaning into l_meaning from mfg_lookups where lookup_code = l_argument2

1128: -- Format of the message text is as follows
1129: -- Data Period= TOKEN1 TOKEN2 ,No. Of Working Hrs/day=TOKEN3, Utilization Rate=TOKEN4%
1130:
1131:
1132: select meaning into l_meaning from mfg_lookups where lookup_code = l_argument2
1133: and lookup_type = 'WMS_ELS_FUTURE_PERIOD';
1134:
1135: IF g_debug=1 THEN
1136: debug('Data period Unit from lookup = '|| l_meaning,'get_parameter_string');

Line 1348: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1

1344: FUNCTION getWorkOutstanding(l_ActivityId IN NUMBER, l_ActivityDetailId IN NUMBER, l_OrgId IN NUMBER)
1345: RETURN VARCHAR2 IS
1346: CURSOR CUR_WRK_OUTSTANDING(p_ActivityId number, p_activityDetailId number, p_OrgId number) IS
1347: SELECT COUNT(*) || ' ' || NVL(DOCUMENT_TYPE, ML1.MEANING) AS WORK
1348: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1
1349: WHERE ORGANIZATION_ID = p_OrgId
1350: AND ACTIVITY_ID = p_ActivityId
1351: AND ACTIVITY_DETAIL_ID = p_ActivityDetailId
1352: AND ML1.LOOKUP_TYPE = 'WMS_ELS_TASKS_LOOKUP'

Line 1377: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1

1373: RETURN NUMBER
1374: IS
1375: CURSOR CUR_WRK_OUTSTANDING(p_ActivityId number, p_activityDetailId number, p_OrgId number) IS
1376: SELECT COUNT(*) AS WORK
1377: FROM WMS_ELS_EXP_RESOURCE, MFG_LOOKUPS ML1
1378: WHERE ORGANIZATION_ID = p_OrgId
1379: AND ACTIVITY_ID = p_ActivityId
1380: AND ACTIVITY_DETAIL_ID = p_ActivityDetailId
1381: AND ML1.LOOKUP_TYPE = 'WMS_ELS_TASKS_LOOKUP';

Line 1408: FROM mfg_lookups

1404: l_points := 4;
1405: END IF;
1406: SELECT meaning
1407: INTO rating
1408: FROM mfg_lookups
1409: WHERE lookup_type = 'WMS_LABOR_RATINGS' AND lookup_code = l_points;
1410:
1411: RETURN rating;
1412: EXCEPTION