INV_ITEM_SUB_EXP_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.ASSET_INVENTORY = 2 AND (A.SUBINVENTORY_TYPE = 1 OR A.SUBINVENTORY_TYPE IS NULL)