INV_ITEM_SUB_TRK_ALL

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Query

SQL_Statement
SELECT SECONDARY_INVENTORY_NAME , SEC.ORGANIZATION_ID , INVENTORY_ITEM_ID , DESCRIPTION , INVENTORY_ATP_CODE , AVAILABILITY_TYPE , RESERVABLE_TYPE , LOCATOR_TYPE , SEC.PICKING_ORDER , QUANTITY_TRACKED , ASSET_INVENTORY , SEC.SOURCE_TYPE , SEC.SOURCE_SUBINVENTORY , SEC.SOURCE_ORGANIZATION_ID , REQUISITION_APPROVAL_TYPE , SEC.DISABLE_DATE , SEC.PROJECT_ID , SEC.TASK_ID , SEC.SUBINVENTORY_USAGE FROM INV_SECONDARY_INVENTORIES SEC, INV_ITEM_SUB_INVENTORIES ITEM WHERE SEC.SECONDARY_INVENTORY_NAME = ITEM.SECONDARY_INVENTORY AND SEC.ORGANIZATION_ID = ITEM.ORGANIZATION_ID AND QUANTITY_TRACKED = 1 AND (SEC.SUBINVENTORY_TYPE = 1 OR SEC.SUBINVENTORY_TYPE IS NULL)

SQL_Statement

SELECT SECONDARY_INVENTORY_NAME , SEC.ORGANIZATION_ID , INVENTORY_ITEM_ID , DESCRIPTION , INVENTORY_ATP_CODE , AVAILABILITY_TYPE , RESERVABLE_TYPE , LOCATOR_TYPE , SEC.PICKING_ORDER , QUANTITY_TRACKED , ASSET_INVENTORY , SEC.SOURCE_TYPE , SEC.SOURCE_SUBINVENTORY , SEC.SOURCE_ORGANIZATION_ID , REQUISITION_APPROVAL_TYPE , SEC.DISABLE_DATE , SEC.PROJECT_ID , SEC.TASK_ID , SEC.SUBINVENTORY_USAGE FROM INV_SECONDARY_INVENTORIES SEC, INV_ITEM_SUB_INVENTORIES ITEM WHERE SEC.SECONDARY_INVENTORY_NAME = ITEM.SECONDARY_INVENTORY AND SEC.ORGANIZATION_ID = ITEM.ORGANIZATION_ID AND QUANTITY_TRACKED = 1 AND (SEC.SUBINVENTORY_TYPE = 1 OR SEC.SUBINVENTORY_TYPE IS NULL)