View: CSP_ASL_ITEMS_V

Product:	CSP - Spares Management
Description:	This view lists all items on a stocklist
Implementation/DBA Data:	APPS.CSP_ASL_ITEMS_V

View Text

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

Columns