View: EAM_SUPPRESSION_RELATIONS_V

Product:	EAM - Enterprise Asset Management
Description:	View shows asset and suppression rules relation details
Implementation/DBA Data:	APPS.EAM_SUPPRESSION_RELATIONS_V

View Text

SELECT SP.ROWID
, SP.PARENT_ASSOCIATION_ID
, MSN.SERIAL_NUMBER
, MSN.INVENTORY_ITEM_ID
, PA.ASSET_ACTIVITY_ID
, SP.CHILD_ASSOCIATION_ID
, CA.ASSET_ACTIVITY_ID
, SP.DESCRIPTION
, SP.CREATED_BY
, SP.CREATION_DATE
, SP.LAST_UPDATE_LOGIN
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
, SP.ATTRIBUTE_CATEGORY
, SP.ATTRIBUTE1
, SP.ATTRIBUTE2
, SP.ATTRIBUTE3
, SP.ATTRIBUTE4
, SP.ATTRIBUTE5
, SP.ATTRIBUTE6
, SP.ATTRIBUTE7
, SP.ATTRIBUTE8
, SP.ATTRIBUTE9
, SP.ATTRIBUTE10
, SP.ATTRIBUTE11
, SP.ATTRIBUTE12
, SP.ATTRIBUTE13
, SP.ATTRIBUTE14
, SP.ATTRIBUTE15
FROM EAM_SUPPRESSION_RELATIONS SP
, MTL_SERIAL_NUMBERS MSN
, MTL_EAM_ASSET_ACTIVITIES PA
, MTL_EAM_ASSET_ACTIVITIES CA
WHERE SP.PARENT_ASSOCIATION_ID = PA.ACTIVITY_ASSOCIATION_ID
AND SP.CHILD_ASSOCIATION_ID = CA.ACTIVITY_ASSOCIATION_ID
AND PA.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND PA.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND PA.SERIAL_NUMBER = MSN.SERIAL_NUMBER
AND NVL(PA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(PA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(CA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(CA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE UNION SELECT SP.ROWID
, SP.PARENT_ASSOCIATION_ID
, NULL
, MSI.INVENTORY_ITEM_ID
, PA.ASSET_ACTIVITY_ID
, SP.CHILD_ASSOCIATION_ID
, CA.ASSET_ACTIVITY_ID
, SP.DESCRIPTION
, SP.CREATED_BY
, SP.CREATION_DATE
, SP.LAST_UPDATE_LOGIN
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
, SP.ATTRIBUTE_CATEGORY
, SP.ATTRIBUTE1
, SP.ATTRIBUTE2
, SP.ATTRIBUTE3
, SP.ATTRIBUTE4
, SP.ATTRIBUTE5
, SP.ATTRIBUTE6
, SP.ATTRIBUTE7
, SP.ATTRIBUTE8
, SP.ATTRIBUTE9
, SP.ATTRIBUTE10
, SP.ATTRIBUTE11
, SP.ATTRIBUTE12
, SP.ATTRIBUTE13
, SP.ATTRIBUTE14
, SP.ATTRIBUTE15
FROM EAM_SUPPRESSION_RELATIONS SP
, MTL_SYSTEM_ITEMS MSI
, MTL_EAM_ASSET_ACTIVITIES PA
, MTL_EAM_ASSET_ACTIVITIES CA
WHERE SP.PARENT_ASSOCIATION_ID = PA.ACTIVITY_ASSOCIATION_ID
AND SP.CHILD_ASSOCIATION_ID = CA.ACTIVITY_ASSOCIATION_ID
AND PA.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND PA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PA.SERIAL_NUMBER IS NULL
AND NVL(PA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(PA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(CA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(CA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE

Columns