DBA Data[Home] [Help]

APPS.WIP_EAM_WORKREQUEST_PVT dependencies on MFG_LOOKUPS

Line 1136: FROM MFG_LOOKUPS

1132: l_stmt_num := 160;
1133: BEGIN
1134: SELECT meaning
1135: INTO l_old_data
1136: FROM MFG_LOOKUPS
1137: WHERE lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY'
1138: AND lookup_code = l_old_priority_id;
1139: EXCEPTION
1140: WHEN NO_DATA_FOUND THEN

Line 1147: FROM MFG_LOOKUPS

1143: l_stmt_num := 170;
1144: BEGIN
1145: SELECT meaning
1146: INTO l_new_data
1147: FROM MFG_LOOKUPS
1148: WHERE lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY'
1149: AND lookup_code = l_new_priority_id;
1150: EXCEPTION
1151: WHEN NO_DATA_FOUND THEN

Line 1192: FROM MFG_LOOKUPS

1188: l_stmt_num := 184;
1189: BEGIN
1190: SELECT meaning
1191: INTO l_old_data
1192: FROM MFG_LOOKUPS
1193: WHERE lookup_type = 'WIP_EAM_WORK_REQ_TYPE'
1194: AND lookup_code = NVL(l_old_work_request_type_id,0);
1195: EXCEPTION
1196: When NO_DATA_FOUND then

Line 1203: FROM MFG_LOOKUPS

1199: l_stmt_num := 186;
1200: BEGIN
1201: SELECT meaning
1202: INTO l_new_data
1203: FROM MFG_LOOKUPS
1204: WHERE lookup_type = 'WIP_EAM_WORK_REQ_TYPE'
1205: AND lookup_code = l_new_work_request_type_id;
1206: EXCEPTION
1207: When NO_DATA_FOUND then

Line 1247: FROM MFG_LOOKUPS

1243: l_stmt_num := 200;
1244: BEGIN
1245: SELECT meaning
1246: INTO l_old_data
1247: FROM MFG_LOOKUPS
1248: WHERE lookup_type = 'WIP_EAM_WORK_REQ_STATUS'
1249: AND lookup_code = l_old_status_id;
1250: EXCEPTION
1251: WHEN NO_DATA_FOUND THEN

Line 1258: FROM MFG_LOOKUPS

1254: l_stmt_num := 210;
1255: BEGIN
1256: SELECT meaning
1257: INTO l_new_data
1258: FROM MFG_LOOKUPS
1259: WHERE lookup_type = 'WIP_EAM_WORK_REQ_STATUS'
1260: AND lookup_code = l_new_status_id;
1261: EXCEPTION
1262: WHEN NO_DATA_FOUND THEN

Line 1512: FROM MFG_LOOKUPS

1508: FROM DUAL;
1509: BEGIN
1510: SELECT meaning
1511: INTO l_old_data
1512: FROM MFG_LOOKUPS
1513: WHERE lookup_type = 'SYS_YES_NO'
1514: AND lookup_code = l_old_notify_originator;
1515: EXCEPTION
1516: When NO_DATA_FOUND then

Line 1522: FROM MFG_LOOKUPS

1518: END;
1519: BEGIN
1520: SELECT meaning
1521: INTO l_new_data
1522: FROM MFG_LOOKUPS
1523: WHERE lookup_type = 'SYS_YES_NO'
1524: AND lookup_code = l_new_notify_originator;
1525: EXCEPTION
1526: When NO_DATA_FOUND then

Line 1563: FROM MFG_LOOKUPS

1559: FROM DUAL;
1560: BEGIN
1561: SELECT meaning
1562: INTO l_old_data
1563: FROM MFG_LOOKUPS
1564: WHERE lookup_type = 'WIP_EAM_CONTACT_PREFERENCE'
1565: AND lookup_code = l_old_contact_preference;
1566: EXCEPTION
1567: When NO_DATA_FOUND then

Line 1573: FROM MFG_LOOKUPS

1569: END;
1570: BEGIN
1571: SELECT meaning
1572: INTO l_new_data
1573: FROM MFG_LOOKUPS
1574: WHERE lookup_type = 'WIP_EAM_CONTACT_PREFERENCE'
1575: AND lookup_code = l_new_contact_preference;
1576: EXCEPTION
1577: When NO_DATA_FOUND then

Line 2348: from mfg_lookups

2344: l_count number;
2345: begin
2346: begin
2347: select count(*) into l_count
2348: from mfg_lookups
2349: where lookup_code = p_lookup_code
2350: and lookup_type = p_lookup_type
2351: and enabled_flag = 'Y'
2352: and sysdate between nvl(start_date_active,sysdate-1)