View: CSP_NOTIFICATION_DETAILS_V

Product:	CSP - Spares Management
Description:	Lists notification recommendations
Implementation/DBA Data:	APPS.CSP_NOTIFICATION_DETAILS_V

View Text

SELECT CND.NOTIFICATION_DETAIL_ID
, CND.NOTIFICATION_ID
, CND.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSIK.DESCRIPTION
, CND.AVAILABLE_QUANTITY
, CND.ORDER_BY_DATE
, CND.SOURCE_TYPE
, FL.MEANING
, CND.SOURCE_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, CND.SOURCE_SUBINVENTORY
, CND.CREATED_BY
, CND.CREATION_DATE
, CND.LAST_UPDATED_BY
, CND.LAST_UPDATE_DATE
, CND.LAST_UPDATE_LOGIN
, CND.ATTRIBUTE_CATEGORY
, CND.ATTRIBUTE1
, CND.ATTRIBUTE2
, CND.ATTRIBUTE3
, CND.ATTRIBUTE4
, CND.ATTRIBUTE5
, CND.ATTRIBUTE6
, CND.ATTRIBUTE7
, CND.ATTRIBUTE8
, CND.ATTRIBUTE9
, CND.ATTRIBUTE10
, CND.ATTRIBUTE11
, CND.ATTRIBUTE12
, CND.ATTRIBUTE13
, CND.ATTRIBUTE14
, CND.ATTRIBUTE15
FROM CSP_NOTIFICATION_DETAILS CND
, MTL_SYSTEM_ITEMS_KFV MSIK
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_LOOKUPS FL
WHERE OOD.ORGANIZATION_ID(+) = CND.SOURCE_ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = NVL(CND.SOURCE_ORGANIZATION_ID
, FND_PROFILE.VALUE('ASO_PRODUCT_ORGANIZATION_ID'))
AND MSIK.INVENTORY_ITEM_ID = CND.INVENTORY_ITEM_ID
AND FL.LOOKUP_CODE = CND.SOURCE_TYPE
AND FL.LOOKUP_TYPE = 'CSP_NOTIF_DTL_SRC_TYPE'

Columns