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

TABLE: CSD.CSD_RO_SAVEDSEARCHES

Object Details
Object Name: CSD_RO_SAVEDSEARCHES
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_RO_SAVEDSEARCHES
Subobject Name:
Status: VALID


This table stores search attributes to be used to searh
repair orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
USER_ID NUMBER (15) Yes User Id (foreign key to FND_USER.USER_ID)
SEARCHNAME VARCHAR2 (80) Yes Search name
DEFAULTFLAG VARCHAR2 (1)
Indicate whether the search is user's default.
REPAIR_NUMBER VARCHAR2 (30)
Repair Order Number
REPAIR_TYPE_ID NUMBER

Repair Type Id
INSTALL_SITE_USE_ID NUMBER

Install Site Use Id
INCIDENT_NUMBER VARCHAR2 (64)
Service Request instance number
INCIDENT_ID NUMBER

SR incident_id
REFERENCE_NUMBER VARCHAR2 (30)
IB Reference Number
INVENTORY_ITEM_ID NUMBER

Inventory product ID
ITEM VARCHAR2 (40)
Product
SERIAL_NUMBER VARCHAR2 (30)
Serial number
RMA_NUMBER VARCHAR2 (30)
Return Material Authorization number
SALES_ORDER_NUMBER VARCHAR2 (30)
Sale Order Number
DATE_CREATED DATE

The date RO was created
PROMISE_DATE DATE

RO Promise Date
DATE_CLOSED DATE

RO close date
STATUS VARCHAR2 (30)
RO Status
ACCOUNT_NUMBER VARCHAR2 (30)
Customer account number.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Standard Application column
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PARTY_ID NUMBER

Party Id for multi-party support
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 does not reference any database object

CSD.CSD_RO_SAVEDSEARCHES is referenced by following:

SchemaCSD
ViewCSD_RO_SAVEDSEARCHES#