INV_SUBINVENTORIES_ALL_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

SECONDARY_INVENTORY_NAME ORGANIZATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DESCRIPTION DISABLE_DATE INVENTORY_ATP_CODE AVAILABILITY_TYPE RESERVABLE_TYPE LOCATOR_TYPE PICKING_ORDER QUANTITY_TRACKED ASSET_INVENTORY SOURCE_TYPE SOURCE_SUBINVENTORY SOURCE_ORGANIZATION_ID REQUISITION_APPROVAL_TYPE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PREPROCESSING_LEAD_TIME PROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME DEMAND_CLASS PROJECT_ID TASK_ID SUBINVENTORY_USAGE LPN_CONTROLLED_FLAG

Query

SQL_Statement

SELECT SECONDARY_INVENTORY_NAME , ORGANIZATION_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , DESCRIPTION , DISABLE_DATE , INVENTORY_ATP_CODE , AVAILABILITY_TYPE , RESERVABLE_TYPE , LOCATOR_TYPE , PICKING_ORDER , QUANTITY_TRACKED , ASSET_INVENTORY , SOURCE_TYPE , SOURCE_SUBINVENTORY , SOURCE_ORGANIZATION_ID , REQUISITION_APPROVAL_TYPE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , REQUEST_ID , JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, PREPROCESSING_LEAD_TIME , PROCESSING_LEAD_TIME , POSTPROCESSING_LEAD_TIME , DEMAND_CLASS , PROJECT_ID , TASK_ID , SUBINVENTORY_USAGE , LPN_CONTROLLED_FLAG FROM INV_SECONDARY_INVENTORIES WHERE SUBINVENTORY_TYPE = 1 OR SUBINVENTORY_TYPE IS NULL