INV_ITEM_SUB_VAL_V
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: VIEW
Columns
Name |
---|
SECONDARY_INVENTORY_NAME ORGANIZATION_ID INVENTORY_ITEM_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 |
Query
SQL_Statement |
---|
SELECT A.SECONDARY_INVENTORY_NAME , A.ORGANIZATION_ID , B.INVENTORY_ITEM_ID , A.DESCRIPTION , A.INVENTORY_ATP_CODE , A.AVAILABILITY_TYPE , A.RESERVABLE_TYPE , A.LOCATOR_TYPE , A.PICKING_ORDER , A.QUANTITY_TRACKED , A.ASSET_INVENTORY , A.SOURCE_TYPE , A.SOURCE_SUBINVENTORY , A.SOURCE_ORGANIZATION_ID , A.REQUISITION_APPROVAL_TYPE , A.PROJECT_ID , A.TASK_ID , A.SUBINVENTORY_USAGE FROM INV_SECONDARY_INVENTORIES A , INV_ITEM_SUB_INVENTORIES B WHERE B.SECONDARY_INVENTORY = A.SECONDARY_INVENTORY_NAME AND A.ORGANIZATION_ID = B.ORGANIZATION_ID AND NVL(DISABLE_DATE,SYSDATE) >= TRUNC(SYSDATE) AND (A.SUBINVENTORY_TYPE = 1 OR A.SUBINVENTORY_TYPE IS NULL) |