VIEW: APPS.WMS_DEPT_SUBINVENTORIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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