INV_SECONDARY_INVENTORIES

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
SECONDARY_INVENTORY_NAME STANDARD_PACK_TYPE STRUCTURE_INSTANCE_NUMBER ORGANIZATION_ID 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 SOURCE_TYPE SOURCE_SUBINVENTORY SOURCE_ORGANIZATION_ID REQUISITION_APPROVAL_TYPE FILL_KILL_TO_LOOKUP ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PREPROCESSING_LEAD_TIME PROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME DEMAND_CLASS PROJECT_ID TASK_ID SUBINVENTORY_USAGE LOCATION_ID PICK_UOM_CODE DEPRECIABLE_FLAG STATUS_ID DEFAULT_LOC_STATUS_ID LPN_CONTROLLED_FLAG PICK_METHODOLOGY CARTONIZATION_FLAG DROPPING_ORDER SUBINVENTORY_TYPE PLANNING_LEVEL DEFAULT_COUNT_TYPE_CODE COUNT_METHOD SUBINVENTORY_GROUP ENABLE_BULK_PICK ENABLE_LOCATOR_ALIAS ENFORCE_ALIAS_UNIQUENESS JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ORACLE_HEALTH_LOCATION USE_SUB_MFG_MNT_IN_WMS USE_PACK_UNIT_COMP_RET ALLOW_OFFLINE_MODE AUTO_CREATE_DELIVERIES FULL_LPN_FLAG SUBINVENTORY_NAME_MLS DESCRIPTION LANGUAGE

Name

SECONDARY_INVENTORY_NAME

STANDARD_PACK_TYPE

STRUCTURE_INSTANCE_NUMBER

ORGANIZATION_ID

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

SOURCE_TYPE

SOURCE_SUBINVENTORY

SOURCE_ORGANIZATION_ID

REQUISITION_APPROVAL_TYPE

FILL_KILL_TO_LOOKUP

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

REQUEST_ID

PREPROCESSING_LEAD_TIME

PROCESSING_LEAD_TIME

POSTPROCESSING_LEAD_TIME

DEMAND_CLASS

PROJECT_ID

TASK_ID

SUBINVENTORY_USAGE

LOCATION_ID

PICK_UOM_CODE

DEPRECIABLE_FLAG

STATUS_ID

DEFAULT_LOC_STATUS_ID

LPN_CONTROLLED_FLAG

PICK_METHODOLOGY

CARTONIZATION_FLAG

DROPPING_ORDER

SUBINVENTORY_TYPE

PLANNING_LEVEL

DEFAULT_COUNT_TYPE_CODE

COUNT_METHOD

SUBINVENTORY_GROUP

ENABLE_BULK_PICK

ENABLE_LOCATOR_ALIAS

ENFORCE_ALIAS_UNIQUENESS

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

ORACLE_HEALTH_LOCATION

USE_SUB_MFG_MNT_IN_WMS

USE_PACK_UNIT_COMP_RET

ALLOW_OFFLINE_MODE

AUTO_CREATE_DELIVERIES

FULL_LPN_FLAG

SUBINVENTORY_NAME_MLS

DESCRIPTION

LANGUAGE

Query

SQL_Statement
select B.SECONDARY_INVENTORY_NAME, B.STANDARD_PACK_TYPE, B.STRUCTURE_INSTANCE_NUMBER, B.ORGANIZATION_ID, 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.SOURCE_TYPE, B.SOURCE_SUBINVENTORY, B.SOURCE_ORGANIZATION_ID, B.REQUISITION_APPROVAL_TYPE, B.FILL_KILL_TO_LOOKUP , B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.REQUEST_ID, B.PREPROCESSING_LEAD_TIME, B.PROCESSING_LEAD_TIME, B.POSTPROCESSING_LEAD_TIME, B.DEMAND_CLASS, B.PROJECT_ID, B.TASK_ID, B.SUBINVENTORY_USAGE, B.LOCATION_ID, B.PICK_UOM_CODE, B.DEPRECIABLE_FLAG, B.STATUS_ID, B.DEFAULT_LOC_STATUS_ID, B.LPN_CONTROLLED_FLAG, B.PICK_METHODOLOGY , B.CARTONIZATION_FLAG , B.DROPPING_ORDER , B.SUBINVENTORY_TYPE , B.PLANNING_LEVEL , B.DEFAULT_COUNT_TYPE_CODE , B.COUNT_METHOD , B.SUBINVENTORY_GROUP , B.ENABLE_BULK_PICK , B.ENABLE_LOCATOR_ALIAS , B.ENFORCE_ALIAS_UNIQUENESS , B.JOB_DEFINITION_NAME , B.JOB_DEFINITION_PACKAGE , B.ORACLE_HEALTH_LOCATION , B.USE_SUB_MFG_MNT_IN_WMS , B.USE_PACK_UNIT_COMP_RET , B.ALLOW_OFFLINE_MODE , B.AUTO_CREATE_DELIVERIES , B.FULL_LPN_FLAG , T.SUBINVENTORY_NAME_MLS , T.DESCRIPTION , T.LANGUAGE FROM INV_SECONDARY_INVENTORIES B, INV_SECONDARY_INVENTORIES_TL T WHERE B.ORGANIZATION_ID = T.ORGANIZATION_ID AND B.SECONDARY_INVENTORY_NAME = T.SECONDARY_INVENTORY_NAME AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

select

B.SECONDARY_INVENTORY_NAME,

B.STANDARD_PACK_TYPE,

B.STRUCTURE_INSTANCE_NUMBER,

B.ORGANIZATION_ID,

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.SOURCE_TYPE,

B.SOURCE_SUBINVENTORY,

B.SOURCE_ORGANIZATION_ID,

B.REQUISITION_APPROVAL_TYPE,

B.FILL_KILL_TO_LOOKUP ,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.REQUEST_ID,

B.PREPROCESSING_LEAD_TIME,

B.PROCESSING_LEAD_TIME,

B.POSTPROCESSING_LEAD_TIME,

B.DEMAND_CLASS,

B.PROJECT_ID,

B.TASK_ID,

B.SUBINVENTORY_USAGE,

B.LOCATION_ID,

B.PICK_UOM_CODE,

B.DEPRECIABLE_FLAG,

B.STATUS_ID,

B.DEFAULT_LOC_STATUS_ID,

B.LPN_CONTROLLED_FLAG,

B.PICK_METHODOLOGY ,

B.CARTONIZATION_FLAG ,

B.DROPPING_ORDER ,

B.SUBINVENTORY_TYPE ,

B.PLANNING_LEVEL ,

B.DEFAULT_COUNT_TYPE_CODE ,

B.COUNT_METHOD ,

B.SUBINVENTORY_GROUP ,

B.ENABLE_BULK_PICK ,

B.ENABLE_LOCATOR_ALIAS ,

B.ENFORCE_ALIAS_UNIQUENESS ,

B.JOB_DEFINITION_NAME ,

B.JOB_DEFINITION_PACKAGE ,

B.ORACLE_HEALTH_LOCATION ,

B.USE_SUB_MFG_MNT_IN_WMS ,

B.USE_PACK_UNIT_COMP_RET ,

B.ALLOW_OFFLINE_MODE ,

B.AUTO_CREATE_DELIVERIES ,

B.FULL_LPN_FLAG ,

T.SUBINVENTORY_NAME_MLS ,

T.DESCRIPTION ,

T.LANGUAGE

FROM

INV_SECONDARY_INVENTORIES B,

INV_SECONDARY_INVENTORIES_TL T

WHERE

B.ORGANIZATION_ID = T.ORGANIZATION_ID

AND B.SECONDARY_INVENTORY_NAME = T.SECONDARY_INVENTORY_NAME

AND T.LANGUAGE = USERENV('LANG')