DBA Data[Home] [Help] [Dependency Information]

VIEW: CSD.CSD_RO_SAVEDSEARCHES#

Object Details
Object Name: CSD_RO_SAVEDSEARCHES#
Object Type: VIEW
Owner: CSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
USER_ID NUMBER (15) Yes
SEARCHNAME VARCHAR2 (80) Yes
DEFAULTFLAG VARCHAR2 (1)
REPAIR_NUMBER VARCHAR2 (30)
REPAIR_TYPE_ID NUMBER

INSTALL_SITE_USE_ID NUMBER

INCIDENT_NUMBER VARCHAR2 (64)
INCIDENT_ID NUMBER

REFERENCE_NUMBER VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER

ITEM VARCHAR2 (40)
SERIAL_NUMBER VARCHAR2 (30)
RMA_NUMBER VARCHAR2 (30)
SALES_ORDER_NUMBER VARCHAR2 (30)
DATE_CREATED DATE

PROMISE_DATE DATE

DATE_CLOSED DATE

STATUS VARCHAR2 (30)
ACCOUNT_NUMBER VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER

SECURITY_GROUP_ID NUMBER

CREATED_BY NUMBER
Yes
PARTY_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      USER_ID
,      SEARCHNAME
,      DEFAULTFLAG
,      REPAIR_NUMBER
,      REPAIR_TYPE_ID
,      INSTALL_SITE_USE_ID
,      INCIDENT_NUMBER
,      INCIDENT_ID
,      REFERENCE_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM
,      SERIAL_NUMBER
,      RMA_NUMBER
,      SALES_ORDER_NUMBER
,      DATE_CREATED
,      PROMISE_DATE
,      DATE_CLOSED
,      STATUS
,      ACCOUNT_NUMBER
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      CREATED_BY
,      PARTY_ID
FROM CSD.CSD_RO_SAVEDSEARCHES#;

Dependencies

[top of page]

CSD.CSD_RO_SAVEDSEARCHES# references the following:

SchemaCSD
TableCSD_RO_SAVEDSEARCHES
CSD.CSD_RO_SAVEDSEARCHES# is referenced by following:

SchemaAPPS
SynonymCSD_RO_SAVEDSEARCHES