View: CS_INCIDENTS_PURGE_AUDIT_VL

Product:	CS - Service
Description:	This is a _VL view. This view will be based on table cs_incidents_purge_audit_b and cs_incidents_purge_audit_tl table.
Implementation/DBA Data:	APPS.CS_INCIDENTS_PURGE_AUDIT_VL

View Text

SELECT B.ROWID ROW_ID
, B.PURGE_ID
, B.INCIDENT_ID
, B.INCIDENT_NUMBER
, B.INCIDENT_TYPE_ID
, B.CUSTOMER_ID
, B.INVENTORY_ITEM_ID
, B.INV_ORGANIZATION_ID
, B.CUSTOMER_PRODUCT_ID
, B.INC_CREATION_DATE
, B.INC_LAST_UPDATE_DATE
, TL.SUMMARY
, TL.LANGUAGE
, TL.SOURCE_LANG
, B.PURGED_DATE
, B.PURGED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM CS_INCIDENTS_PURGE_AUDIT_B B
, CS_INCIDENTS_PURGE_AUDIT_TL TL
WHERE B.INCIDENT_ID = TL.INCIDENT_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns