INV_SUBINVENTORIES_SEEDDATA_VL

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

STRUCTURE_INSTANCE_NUMBER OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DISABLE_DATE INVENTORY_ATP_CODE AVAILABILITY_TYPE RESERVABLE_TYPE LOCATOR_TYPE PICKING_ORDER QUANTITY_TRACKED SUBINVENTORY_ID ASSET_INVENTORY PREPROCESSING_LEAD_TIME PROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME LOCATION_ID DEPRECIABLE_FLAG STATUS_ID DEFAULT_LOC_STATUS_ID SUBINVENTORY_TYPE SECONDARY_INVENTORY_NAME DESCRIPTION

Query

SQL_Statement

SELECT B.STRUCTURE_INSTANCE_NUMBER , B.OBJECT_VERSION_NUMBER , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.DISABLE_DATE , B.INVENTORY_ATP_CODE , B.AVAILABILITY_TYPE , B.RESERVABLE_TYPE , B.LOCATOR_TYPE , B.PICKING_ORDER , B.QUANTITY_TRACKED , B.SUBINVENTORY_ID , B.ASSET_INVENTORY , B.PREPROCESSING_LEAD_TIME , B.PROCESSING_LEAD_TIME , B.POSTPROCESSING_LEAD_TIME , B.LOCATION_ID , B.DEPRECIABLE_FLAG , B.STATUS_ID , B.DEFAULT_LOC_STATUS_ID , B.SUBINVENTORY_TYPE , T.SECONDARY_INVENTORY_NAME , T.DESCRIPTION FROM INV_SUBINVENTORIES_SEEDDATA_B B,INV_SUBINVENTORIES_SEEDDATA_TL T WHERE B.SUBINVENTORY_ID = T.SUBINVENTORY_ID AND T.LANGUAGE = userenv('LANG')