Product: | EAM - Enterprise Asset Management |
---|---|
Description: | This view shows suppression relationships between a parent activity on an asset and the child activities suppressed by it. |
Implementation/DBA Data: | APPS.EAM_SUPPRESSION_RELATIONS_V |
SELECT SP.ROWID
, SP.PARENT_ASSOCIATION_ID
, PA.ASSET_ACTIVITY_ID
, SP.CHILD_ASSOCIATION_ID
, CA.ASSET_ACTIVITY_ID
, (SELECT MSI.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_B_KFV MSI
WHERE MSI.INVENTORY_ITEM_ID = CA.ASSET_ACTIVITY_ID
AND ROWNUM=1)
, 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
, PA.MAINTENANCE_OBJECT_TYPE
, PA.MAINTENANCE_OBJECT_ID
FROM EAM_SUPPRESSION_RELATIONS SP
, 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 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