[Home] [Help]
137: CURSOR INVENTORY_LABEL(ID IN NUMBER,ORG_ID IN NUMBER) IS
138: SELECT
139: DESCRIPTION
140: FROM
141: MTL_SYSTEM_ITEMS_VL
142: WHERE INVENTORY_ITEM_ID = ID
143: AND ORGANIZATION_ID = ORG_ID;
144: NAME VARCHAR2(800);
145: USE_SHIPPER_NAME BOOLEAN := TRUE;