VIEW: APPS.CS_INCIDENTS_PURGE_AUDIT_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')