APPS.WIP_LOCATOR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 67

                  '(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||
                  'WHERE INVENTORY_ITEM_ID = ' ||
                  TO_CHAR(P_Item_Id) ||
                  ' AND ORGANIZATION_ID = ' || to_char(P_Organization_Id)
                  || ' AND SUBINVENTORY_CODE = ' || P_Subinventory_Code || ')'; */

Line: 80

                  '(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||
                  'WHERE INVENTORY_ITEM_ID = ''' ||
                  TO_NUMBER(P_Item_Id) ||'''' ||
                  ' AND ORGANIZATION_ID = ''' || to_number(P_Organization_Id)||''''
                  || ' AND SUBINVENTORY_CODE = ''' || P_Subinventory_Code||'''' || ')';

Line: 120

		SELECT COUNT(*)
		INTO   x_count
		FROM   MTL_ITEM_LOCATIONS
		WHERE  (DISABLE_DATE > SYSDATE or
			DISABLE_DATE IS NULL)
		AND SUBINVENTORY_CODE = P_Subinventory_Code
		AND INVENTORY_LOCATION_ID = P_Locator_Id
		AND INVENTORY_LOCATION_ID IN
		    (SELECT SECONDARY_LOCATOR
		     FROM   MTL_SECONDARY_LOCATORS
		     WHERE  INVENTORY_ITEM_ID = P_Item_Id
		     AND    ORGANIZATION_ID = P_Organization_Id
		     AND    SUBINVENTORY_CODE = P_Subinventory_Code);

Line: 136

		SELECT COUNT(*)
		INTO   x_count
		FROM   MTL_ITEM_LOCATIONS
		WHERE  (DISABLE_DATE > SYSDATE or
			DISABLE_DATE IS NULL)
		AND INVENTORY_LOCATION_ID = P_Locator_Id
		AND NVL(SUBINVENTORY_CODE,'Z')
		  = NVL(P_Subinventory_Code,'Z');

Line: 165

		    UPDATE MTL_ITEM_LOCATIONS
		    SET    SUBINVENTORY_CODE = P_Subinventory_Code
		    WHERE  INVENTORY_LOCATION_ID = P_Locator_Id
		    AND    ORGANIZATION_ID = P_Organization_Id;