View: MTL_ITEM_SUB_INVENTORIES_ALL_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_SUB_INVENTORIES_ALL_V

View Text

SELECT S.ROWID
, S.INVENTORY_ITEM_ID
, I.DESCRIPTION
, S.ORGANIZATION_ID
, S.SECONDARY_INVENTORY
, SUB.DESCRIPTION
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
, S.PRIMARY_SUBINVENTORY_FLAG
, S.PICKING_ORDER
, S.MIN_MINMAX_QUANTITY
, S.MAX_MINMAX_QUANTITY
, S.INVENTORY_PLANNING_CODE
, S.FIXED_LOT_MULTIPLE
, S.MINIMUM_ORDER_QUANTITY
, S.MAXIMUM_ORDER_QUANTITY
, S.SOURCE_TYPE
, S.SOURCE_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, S.SOURCE_SUBINVENTORY
, S.ENCUMBRANCE_ACCOUNT
, S.PREPROCESSING_LEAD_TIME
, S.PROCESSING_LEAD_TIME
, S.POSTPROCESSING_LEAD_TIME
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, SUB.STATUS_ID
, MMS.STATUS_CODE
FROM MTL_ITEM_SUB_INVENTORIES S
, MTL_SECONDARY_INVENTORIES SUB
, MTL_MATERIAL_STATUSES_VL MMS
, MTL_SYSTEM_ITEMS I
, HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MP
WHERE S.SECONDARY_INVENTORY = SUB.SECONDARY_INVENTORY_NAME
AND S.ORGANIZATION_ID = SUB.ORGANIZATION_ID
AND S.SOURCE_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND S.SOURCE_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
AND SUB.STATUS_ID = MMS.STATUS_ID(+)
AND (SUB.SUBINVENTORY_TYPE = 1 OR SUB.SUBINVENTORY_TYPE IS NULL)

Columns