APPS.WSH_WSHRDMBL_XMLP_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 211: FND_LOOKUP_VALUES_VL

207: SELECT
208: MEANING
209: INTO L_MODE_MEAN
210: FROM
211: FND_LOOKUP_VALUES_VL
212: WHERE LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
213: AND LOOKUP_CODE = MODE_OF_TRANSPORT;
214: ELSE
215: L_MODE_MEAN := NULL;

Line 230: FND_LOOKUP_VALUES_VL

226: SELECT
227: MEANING
228: INTO L_SERVICE_LEVEL
229: FROM
230: FND_LOOKUP_VALUES_VL
231: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
232: AND LOOKUP_CODE = SERVICE_LEVEL;
233: ELSE
234: L_SERVICE_LEVEL := NULL;

Line 246: FND_LOOKUP_VALUES_VL

242: SELECT
243: MEANING
244: INTO L_TRIP_STATUS
245: FROM
246: FND_LOOKUP_VALUES_VL
247: WHERE LOOKUP_TYPE = 'TRIP_STATUS'
248: AND LOOKUP_CODE = TRIP_STATUS;
249: RETURN L_TRIP_STATUS;
250: END CF_TRIP_STATUSFORMULA;

Line 259: FND_LOOKUP_VALUES_VL

255: SELECT
256: MEANING
257: INTO L_STOP_STATUS
258: FROM
259: FND_LOOKUP_VALUES_VL
260: WHERE LOOKUP_TYPE = 'TRIP_STOP_STATUS'
261: AND LOOKUP_CODE = STOP_STATUS;
262: RETURN L_STOP_STATUS;
263: END CF_STOP_STATUSFORMULA;

Line 314: FND_LOOKUP_VALUES_VL

310: SELECT
311: MEANING
312: INTO L_STATUS_MEANING
313: FROM
314: FND_LOOKUP_VALUES_VL
315: WHERE LOOKUP_TYPE = 'DELIVERY_STATUS'
316: AND LOOKUP_CODE = DELIVERY_STATUS_DP;
317: RETURN L_STATUS_MEANING;
318: END CF_DELIVERY_STATUS_DPFORMULA;

Line 403: FND_LOOKUP_VALUES_VL

399: SELECT
400: MEANING
401: INTO L_STATUS_MEANING
402: FROM
403: FND_LOOKUP_VALUES_VL
404: WHERE LOOKUP_TYPE = 'DELIVERY_STATUS'
405: AND LOOKUP_CODE = DELIVERY_STATUS_DD;
406: RETURN L_STATUS_MEANING;
407: END CF_DELIVERY_STATUS_DDFORMULA;