INV_SUBINVENTORIES_VAL_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name
SECONDARY_INVENTORY_NAME ORGANIZATION_ID DESCRIPTION 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 PROJECT_ID TASK_ID SUBINVENTORY_USAGE LPN_CONTROLLED_FLAG

Query

SQL_Statement

SELECT SECONDARY_INVENTORY_NAME , ORGANIZATION_ID , DESCRIPTION , 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 , PROJECT_ID , TASK_ID , SUBINVENTORY_USAGE ,LPN_CONTROLLED_FLAG FROM INV_SECONDARY_INVENTORIES WHERE NVL(DISABLE_DATE,SYSDATE) >= TRUNC(SYSDATE) AND (SUBINVENTORY_TYPE = 1 OR SUBINVENTORY_TYPE IS NULL)