View: WMS_DEPT_SUBINVENTORIES_V

Product:	WMS - Warehouse Management
Description:	View for the WMS_Department_Subinventories table
Implementation/DBA Data:	APPS.WMS_DEPT_SUBINVENTORIES_V

View Text

SELECT WDS.ROWID ROW_ID
, WDS.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, WDS.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION DEPARTMENT_DESCRIPTION
, WDS.SUBINVENTORY_CODE
, MSI.DESCRIPTION
, WDS.SUBINVENTORY_ID
, WDS.LAST_UPDATE_DATE
, WDS.LAST_UPDATED_BY
, WDS.LAST_UPDATE_LOGIN
, WDS.CREATED_BY
, WDS.CREATION_DATE
, WDS.EFFECTIVE_FROM_DATE
, WDS.EFFECTIVE_TO_DATE
, WDS.ATTRIBUTE_CATEGORY
, WDS.ATTRIBUTE1
, WDS.ATTRIBUTE2
, WDS.ATTRIBUTE3
, WDS.ATTRIBUTE4
, WDS.ATTRIBUTE5
, WDS.ATTRIBUTE6
, WDS.ATTRIBUTE7
, WDS.ATTRIBUTE8
, WDS.ATTRIBUTE9
, WDS.ATTRIBUTE10
, WDS.ATTRIBUTE11
, WDS.ATTRIBUTE12
, WDS.ATTRIBUTE13
, WDS.ATTRIBUTE14
, WDS.ATTRIBUTE15
FROM WMS_DEPARTMENT_SUBINVENTORIES WDS
, MTL_SECONDARY_INVENTORIES MSI
, BOM_DEPARTMENTS BD
, MTL_PARAMETERS MP
WHERE WDS.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WDS.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND WDS.ORGANIZATION_ID = BD.ORGANIZATION_ID
AND WDS.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND WDS.SUBINVENTORY_CODE = MSI.SECONDARY_INVENTORY_NAME

Columns