APPS.MST_WB_UTIL dependencies on WSH_LOOKUPS

Line 632: FROM Wsh_Lookups

628: AND Lookup_Type = P_Lookup_Type;
629:
630: CURSOR Wl_Cur Is
631: SELECT Meaning
632: FROM Wsh_Lookups
633: WHERE Lookup_Code = P_Lookup_Code
634: AND Lookup_Type = P_Lookup_Type;
635:
636: l_meaning VARCHAR2(80);

Line 1375: FROM mst_trips mt, wsh_lookups wlk

1371: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_220_1');
1372: --Trip_number, mode_of_transport
1373: SELECT mt.trip_number, wlk.meaning
1374: INTO l_id1, l_temp
1375: FROM mst_trips mt, wsh_lookups wlk
1376: WHERE plan_id = P_PLAN_ID
1377: AND trip_id = P_TRIP_ID
1378: and wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT'
1379: and mt.mode_of_transport = wlk.lookup_code;

Line 1612: FROM mst_trips mt, wsh_lookups wlk

1608: --Trip_number, mode_of_transport, facility_description
1609: --Trip_number, mode_of_transport
1610: SELECT mt.trip_number, wlk.meaning
1611: INTO l_id1, l_temp
1612: FROM mst_trips mt, wsh_lookups wlk
1613: WHERE plan_id = P_PLAN_ID
1614: AND trip_id = P_TRIP_ID
1615: and wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT'
1616: and mt.mode_of_transport = wlk.lookup_code;

Line 4882: FROM wsh_lookups wlk

4878: fnd_message.set_token('DELIVERY_DETAIL_ID', l_id2);
4879:
4880: SELECT wlk.meaning
4881: INTO l_str2
4882: FROM wsh_lookups wlk
4883: WHERE wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT'
4884: and wlk.lookup_code = l_str1;
4885: fnd_message.set_token('MODE_OF_TRANSPORT', l_str2);
4886:

Line 5499: FROM wsh_lookups wlk

5495: END IF;
5496:
5497: SELECT wlk.meaning
5498: INTO l_str2
5499: FROM wsh_lookups wlk
5500: WHERE wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT'
5501: and wlk.lookup_code = l_str1;
5502:
5503: fnd_message.set_token('MODE_OF_TRANSPORT', l_str2);