31: FROM
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
62: WPB.NAME
63: FROM
64: WSH_PICKING_BATCHES WPB
65: WHERE WPB.BATCH_ID = V_BATCH_ID;
66: V_SORT_DISPLAY FND_LOOKUP_VALUES_VL.MEANING%TYPE;
67: CURSOR GET_SORT_DISP_MEANING IS
68: SELECT
69: MEANING
70: FROM
203: FROM
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
234: WPB.NAME
235: FROM
236: WSH_PICKING_BATCHES WPB
237: WHERE WPB.BATCH_ID = V_BATCH_ID;
238: V_SORT_DISPLAY FND_LOOKUP_VALUES_VL.MEANING%TYPE;
239: CURSOR GET_SORT_DISP_MEANING IS
240: SELECT
241: MEANING
242: FROM