VIEW: APPS.MTL_ITEM_SUB_INVENTORIES_ALL_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)