APPS.WIP_COMPONENT SQL Statements

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

Line: 188

	SELECT decode(count(*),0,valid_flag,'N')
	INTO VALID_FLAG
	FROM DUAL
	WHERE
	(EXISTS
		 (SELECT 1
		  FROM MTL_SYSTEM_ITEMS MSI
		  WHERE MSI.INVENTORY_ITEM_ID = p_item_id
		  AND   MSI.ORGANIZATION_ID = p_org_id
		  AND   MSI.RESTRICT_SUBINVENTORIES_CODE = 1
		  AND   MSI.INVENTORY_ASSET_FLAG = 'N')
	       AND NOT EXISTS
		  (SELECT 1
		   FROM  MTL_ITEM_SUB_VAL_V MSVV
		   WHERE MSVV.ORGANIZATION_ID = p_org_id
		   AND   MSVV.INVENTORY_ITEM_ID = p_item_id
		   AND   MSVV.SECONDARY_INVENTORY_NAME = p_subinventory));

Line: 208

	SELECT decode(count(*),0,valid_flag,'N')
        INTO VALID_FLAG
	FROM DUAL
        WHERE
	(EXISTS
		 (SELECT 1
		  FROM MTL_SYSTEM_ITEMS MSI
		  WHERE MSI.INVENTORY_ITEM_ID = p_item_id
		  AND   MSI.ORGANIZATION_ID = p_org_id
		  AND   MSI.RESTRICT_SUBINVENTORIES_CODE = 1
		  AND   MSI.INVENTORY_ASSET_FLAG = 'Y')
	       AND NOT EXISTS
		  (SELECT 1
		   FROM  MTL_ITEM_SUB_AST_TRK_VAL_V MSVV
		   WHERE MSVV.ORGANIZATION_ID = p_org_id
		   AND   MSVV.INVENTORY_ITEM_ID = p_item_id
                   AND   MSVV.SECONDARY_INVENTORY_NAME = p_subinventory));

Line: 228

	SELECT decode(count(*),0,valid_flag,'N')
        INTO VALID_FLAG
	FROM DUAL
        WHERE
	NOT EXISTS
		  (SELECT 1
		   FROM  MTL_SUBINVENTORIES_VAL_V MSVV,
			 MTL_SYSTEM_ITEMS MSI
		   WHERE MSVV.ORGANIZATION_ID = p_org_id
		   AND   MSVV.SECONDARY_INVENTORY_NAME = p_subinventory
		   AND   MSI.INVENTORY_ITEM_ID = p_item_id
		   AND   MSI.ORGANIZATION_ID = p_org_id
		   AND   MSI.INVENTORY_ASSET_FLAG = 'N'
		   UNION
		   SELECT 1
		   FROM  MTL_SUB_AST_TRK_VAL_V MSVV,
			 MTL_SYSTEM_ITEMS MSI
		   WHERE MSVV.ORGANIZATION_ID = p_org_id
		   AND   MSVV.SECONDARY_INVENTORY_NAME = p_subinventory
		   AND   MSI.INVENTORY_ITEM_ID = p_item_id
		   AND   MSI.ORGANIZATION_ID = p_org_id
		   AND   MSI.INVENTORY_ASSET_FLAG = 'Y');

Line: 293

		SELECT decode(count(*),0,valid_flag,'N') INTO valid_flag
		FROM DUAL
		WHERE NOT EXISTS
		(SELECT 1
		 FROM   MTL_SECONDARY_LOCATORS msl
		 WHERE  msl.inventory_item_id = p_item_id
		 AND	msl.secondary_locator = p_locator_id
		 AND    msl.organization_id = p_org_id);