Product: | CSP - Spares Management |
---|---|
Description: | Notification Details |
Implementation/DBA Data: | APPS.CSP_NOTIFICATIONS_V |
SELECT CN.ROWID
, CN.CREATED_BY
, CN.CREATION_DATE
, CN.LAST_UPDATED_BY
, CN.LAST_UPDATE_DATE
, CN.LAST_UPDATE_LOGIN
, CN.NOTIFICATION_ID
, CN.PLANNER_CODE
, CN.PARTS_LOOP_ID
, CN.ORGANIZATION_ID
, CN.INVENTORY_ITEM_ID
, CN.NOTIFICATION_DATE
, CN.REASON
, FL1.MEANING
, CN.STATUS
, FL2.MEANING
, CN.QUANTITY
, MSIV.CONCATENATED_SEGMENTS
, MSIV.DESCRIPTION
, MSIV.PRIMARY_UOM_CODE
, CN.ATTRIBUTE_CATEGORY
, CN.ATTRIBUTE1
, CN.ATTRIBUTE2
, CN.ATTRIBUTE3
, CN.ATTRIBUTE4
, CN.ATTRIBUTE5
, CN.ATTRIBUTE6
, CN.ATTRIBUTE7
, CN.ATTRIBUTE8
, CN.ATTRIBUTE9
, CN.ATTRIBUTE10
, CN.ATTRIBUTE11
, CN.ATTRIBUTE12
, CN.ATTRIBUTE13
, CN.ATTRIBUTE14
, CN.ATTRIBUTE15
FROM CSP_NOTIFICATIONS CN
, MTL_SYSTEM_ITEMS_VL MSIV
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
WHERE MSIV.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CN.INVENTORY_ITEM_ID=MSIV.INVENTORY_ITEM_ID
AND CN.REASON =FL1.LOOKUP_CODE
AND FL1.LOOKUP_TYPE ='CSP_NOTIFICATION_TYPES'
AND CN.STATUS =FL2.LOOKUP_CODE
AND FL2.LOOKUP_TYPE ='CSP_NOTIFICATION_STATUS'