View: CSP_ITEM_SUB_INVENTORIES_ALL_V

Product:	CSP - Spares Management
Description:	Shows authorized stocklist for the subinventories.
Implementation/DBA Data:	APPS.CSP_ITEM_SUB_INVENTORIES_ALL_V

View Text

SELECT MIS.ROW_ID
, MIS.INVENTORY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, MIS.ITEM_DESCRIPTION
, MIS.ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME
, MIS.SECONDARY_INVENTORY
, MIS.SUB_DESCRIPTION
, MIS.LAST_UPDATE_DATE
, MIS.LAST_UPDATED_BY
, MIS.CREATION_DATE
, MIS.CREATED_BY
, MIS.LAST_UPDATE_LOGIN
, MIS.PRIMARY_SUBINVENTORY_FLAG
, MIS.PICKING_ORDER
, MIS.MIN_MINMAX_QUANTITY
, MIS.MAX_MINMAX_QUANTITY
, MIS.INVENTORY_PLANNING_CODE
, MIS.FIXED_LOT_MULTIPLE
, MIS.MINIMUM_ORDER_QUANTITY
, MIS.MAXIMUM_ORDER_QUANTITY
, MIS.SOURCE_TYPE
, DECODE(MIS.SOURCE_TYPE
, 1
, 'INVENTORY'
, 2
, 'VENDOR'
, 3
, 'SUBINVENTORY') SOURCE_TYPE_NAME
, MIS.SOURCE_ORGANIZATION_ID
, MIS.SOURCE_ORGANIZATION
, MIS.SOURCE_ORG_NAME
, MIS.SOURCE_SUBINVENTORY
, MIS.ENCUMBRANCE_ACCOUNT
, MIS.PREPROCESSING_LEAD_TIME
, MIS.PROCESSING_LEAD_TIME
, MIS.POSTPROCESSING_LEAD_TIME
, NVL(CSL.MANUAL_AUTO
, 'NO')
, CSL.REASON_CODE
, FND.MEANING REASON_CODE_MEANING
, MIS.ATTRIBUTE_CATEGORY
, MIS.ATTRIBUTE1
, MIS.ATTRIBUTE2
, MIS.ATTRIBUTE3
, MIS.ATTRIBUTE4
, MIS.ATTRIBUTE5
, MIS.ATTRIBUTE6
, MIS.ATTRIBUTE7
, MIS.ATTRIBUTE8
, MIS.ATTRIBUTE9
, MIS.ATTRIBUTE10
, MIS.ATTRIBUTE11
, MIS.ATTRIBUTE12
, MIS.ATTRIBUTE13
, MIS.ATTRIBUTE14
, MIS.ATTRIBUTE15
FROM MTL_ITEM_SUB_INVENTORIES_ALL_V MIS
, MTL_SYSTEM_ITEMS_B_KFV KFV
, CSP_STOCK_LISTS CSL
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_LOOKUPS FND
WHERE MIS.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND MIS.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND MIS.INVENTORY_ITEM_ID = CSL.INVENTORY_ITEM_ID(+)
AND MIS.ORGANIZATION_ID = CSL.ORGANIZATION_ID(+)
AND MIS.SECONDARY_INVENTORY = CSL.SUBINVENTORY_CODE(+)
AND MIS.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND CSL.REASON_CODE = FND.LOOKUP_CODE(+)
AND FND.LOOKUP_TYPE(+) = 'CSP_ASL_REASON_CODE'

Columns