APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on WSH_LOOKUPS

Line 36: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;

32: PO_VENDORS
33: WHERE VENDOR_ID = V_CUST_ID;
34: --RTV changes
35: V_SHIP FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE;
36: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;
37: CURSOR GET_ITEM_DISP_MEANING IS
38: SELECT
39: MEANING
40: FROM

Line 41: WSH_LOOKUPS

37: CURSOR GET_ITEM_DISP_MEANING IS
38: SELECT
39: MEANING
40: FROM
41: WSH_LOOKUPS
42: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
43: AND LOOKUP_CODE = P_ITEM_DISPLAY;
44: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
45: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

Line 71: WSH_LOOKUPS

67: CURSOR GET_SORT_DISP_MEANING IS
68: SELECT
69: MEANING
70: FROM
71: WSH_LOOKUPS
72: WHERE LOOKUP_TYPE = 'OPN_SORT_BY'
73: AND LOOKUP_CODE = P_SORT_BY;
74: BEGIN
75: BEGIN

Line 208: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;

204: PO_VENDORS
205: WHERE VENDOR_ID = V_CUST_ID;
206: --RTV changes
207: V_SHIP FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE;
208: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;
209: CURSOR GET_ITEM_DISP_MEANING IS
210: SELECT
211: MEANING
212: FROM

Line 213: WSH_LOOKUPS

209: CURSOR GET_ITEM_DISP_MEANING IS
210: SELECT
211: MEANING
212: FROM
213: WSH_LOOKUPS
214: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
215: AND LOOKUP_CODE = P_ITEM_DISPLAY;
216: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
217: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

Line 243: WSH_LOOKUPS

239: CURSOR GET_SORT_DISP_MEANING IS
240: SELECT
241: MEANING
242: FROM
243: WSH_LOOKUPS
244: WHERE LOOKUP_TYPE = 'OPN_SORT_BY'
245: AND LOOKUP_CODE = P_SORT_BY;
246: BEGIN
247: IF (P_SHIP_TO IS NULL) THEN