VIEW: APPS.EAM_SUPPRESSION_RELATIONS_V

Source

View Text - Preformatted

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, pa.organization_id, 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 ( (pa.organization_id = ca.organization_id) OR (pa.organization_id is null or ca.organization_id 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

View Text - HTML Formatted

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
, PA.ORGANIZATION_ID
, 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 ( (PA.ORGANIZATION_ID = CA.ORGANIZATION_ID) OR (PA.ORGANIZATION_ID IS NULL OR CA.ORGANIZATION_ID 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