APPS.WIP_EAM_WORKREQUEST_PVT dependencies on MFG_LOOKUPS

Line 1110: FROM MFG_LOOKUPS

1106: l_stmt_num := 160;
1107: BEGIN
1108: SELECT meaning
1109: INTO l_old_data
1110: FROM MFG_LOOKUPS
1111: WHERE lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY'
1112: AND lookup_code = l_old_priority_id;
1113: EXCEPTION
1114: WHEN NO_DATA_FOUND THEN

Line 1121: FROM MFG_LOOKUPS

1117: l_stmt_num := 170;
1118: BEGIN
1119: SELECT meaning
1120: INTO l_new_data
1121: FROM MFG_LOOKUPS
1122: WHERE lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY'
1123: AND lookup_code = l_new_priority_id;
1124: EXCEPTION
1125: WHEN NO_DATA_FOUND THEN

Line 1167: FROM MFG_LOOKUPS

1163: l_stmt_num := 184;
1164: BEGIN
1165: SELECT meaning
1166: INTO l_old_data
1167: FROM MFG_LOOKUPS
1168: WHERE lookup_type = 'WIP_EAM_WORK_REQ_TYPE'
1169: AND lookup_code = NVL(l_old_work_request_type_id,0);
1170: EXCEPTION
1171: When NO_DATA_FOUND then

Line 1178: FROM MFG_LOOKUPS

1174: l_stmt_num := 186;
1175: BEGIN
1176: SELECT meaning
1177: INTO l_new_data
1178: FROM MFG_LOOKUPS
1179: WHERE lookup_type = 'WIP_EAM_WORK_REQ_TYPE'
1180: AND lookup_code = l_new_work_request_type_id;
1181: EXCEPTION
1182: When NO_DATA_FOUND then

Line 1223: FROM MFG_LOOKUPS

1219: l_stmt_num := 200;
1220: BEGIN
1221: SELECT meaning
1222: INTO l_old_data
1223: FROM MFG_LOOKUPS
1224: WHERE lookup_type = 'WIP_EAM_WORK_REQ_STATUS'
1225: AND lookup_code = l_old_status_id;
1226: EXCEPTION
1227: WHEN NO_DATA_FOUND THEN

Line 1234: FROM MFG_LOOKUPS

1230: l_stmt_num := 210;
1231: BEGIN
1232: SELECT meaning
1233: INTO l_new_data
1234: FROM MFG_LOOKUPS
1235: WHERE lookup_type = 'WIP_EAM_WORK_REQ_STATUS'
1236: AND lookup_code = l_new_status_id;
1237: EXCEPTION
1238: WHEN NO_DATA_FOUND THEN

Line 1491: FROM MFG_LOOKUPS

1487: FROM DUAL;
1488: BEGIN
1489: SELECT meaning
1490: INTO l_old_data
1491: FROM MFG_LOOKUPS
1492: WHERE lookup_type = 'SYS_YES_NO'
1493: AND lookup_code = l_old_notify_originator;
1494: EXCEPTION
1495: When NO_DATA_FOUND then

Line 1501: FROM MFG_LOOKUPS

1497: END;
1498: BEGIN
1499: SELECT meaning
1500: INTO l_new_data
1501: FROM MFG_LOOKUPS
1502: WHERE lookup_type = 'SYS_YES_NO'
1503: AND lookup_code = l_new_notify_originator;
1504: EXCEPTION
1505: When NO_DATA_FOUND then

Line 1542: FROM MFG_LOOKUPS

1538: FROM DUAL;
1539: BEGIN
1540: SELECT meaning
1541: INTO l_old_data
1542: FROM MFG_LOOKUPS
1543: WHERE lookup_type = 'WIP_EAM_CONTACT_PREFERENCE'
1544: AND lookup_code = l_old_contact_preference;
1545: EXCEPTION
1546: When NO_DATA_FOUND then

Line 1552: FROM MFG_LOOKUPS

1548: END;
1549: BEGIN
1550: SELECT meaning
1551: INTO l_new_data
1552: FROM MFG_LOOKUPS
1553: WHERE lookup_type = 'WIP_EAM_CONTACT_PREFERENCE'
1554: AND lookup_code = l_new_contact_preference;
1555: EXCEPTION
1556: When NO_DATA_FOUND then

Line 2388: from mfg_lookups

2384: l_count number;
2385: begin
2386: begin
2387: select count(*) into l_count
2388: from mfg_lookups
2389: where lookup_code = p_lookup_code
2390: and lookup_type = p_lookup_type
2391: and enabled_flag = 'Y'
2392: and sysdate between nvl(start_date_active,sysdate-1)