APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on WSH_LOOKUPS

Line 28: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;

24: FROM
25: HZ_CUST_ACCOUNTS
26: WHERE CUST_ACCOUNT_ID = V_CUST_ID;
27: V_SHIP FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE;
28: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;
29: CURSOR GET_ITEM_DISP_MEANING IS
30: SELECT
31: MEANING
32: FROM

Line 33: WSH_LOOKUPS

29: CURSOR GET_ITEM_DISP_MEANING IS
30: SELECT
31: MEANING
32: FROM
33: WSH_LOOKUPS
34: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
35: AND LOOKUP_CODE = P_ITEM_DISPLAY;
36: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
37: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

Line 63: WSH_LOOKUPS

59: CURSOR GET_SORT_DISP_MEANING IS
60: SELECT
61: MEANING
62: FROM
63: WSH_LOOKUPS
64: WHERE LOOKUP_TYPE = 'OPN_SORT_BY'
65: AND LOOKUP_CODE = P_SORT_BY;
66: BEGIN
67: BEGIN

Line 181: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;

177: FROM
178: HZ_CUST_ACCOUNTS
179: WHERE CUST_ACCOUNT_ID = V_CUST_ID;
180: V_SHIP FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE;
181: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;
182: CURSOR GET_ITEM_DISP_MEANING IS
183: SELECT
184: MEANING
185: FROM

Line 186: WSH_LOOKUPS

182: CURSOR GET_ITEM_DISP_MEANING IS
183: SELECT
184: MEANING
185: FROM
186: WSH_LOOKUPS
187: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
188: AND LOOKUP_CODE = P_ITEM_DISPLAY;
189: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
190: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

Line 216: WSH_LOOKUPS

212: CURSOR GET_SORT_DISP_MEANING IS
213: SELECT
214: MEANING
215: FROM
216: WSH_LOOKUPS
217: WHERE LOOKUP_TYPE = 'OPN_SORT_BY'
218: AND LOOKUP_CODE = P_SORT_BY;
219: BEGIN
220: IF (P_SHIP_TO IS NULL) THEN