[Home] [Help] [Dependency Information]
Object Name: | CS_INCIDENTS_PURGE_AUDIT_B# |
---|---|
Object Type: | VIEW |
Owner: | CS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | Yes | ||
INCIDENT_ID | NUMBER | Yes | ||
INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | |
INCIDENT_TYPE_ID | NUMBER | Yes | ||
CUSTOMER_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
INV_ORGANIZATION_ID | NUMBER | |||
CUSTOMER_PRODUCT_ID | NUMBER | |||
INC_CREATION_DATE | DATE | Yes | ||
INC_LAST_UPDATE_DATE | DATE | Yes | ||
PURGED_DATE | DATE | Yes | ||
PURGED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_ID
, INCIDENT_ID
, INCIDENT_NUMBER
, INCIDENT_TYPE_ID
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID
, CUSTOMER_PRODUCT_ID
, INC_CREATION_DATE
, INC_LAST_UPDATE_DATE
, PURGED_DATE
, PURGED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM CS.CS_INCIDENTS_PURGE_AUDIT_B#;
|
|
|