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


TABLE: CS.CS_REPAIRS_ALL

Object Details
Object Name: CS_REPAIRS_ALL
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_REPAIRS_ALL
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CS_REPAIRS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREPAIR_LINE_ID
CS_REPAIRS_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnESTIMATE_BUSINESS_GROUP_ID
CS_REPAIRS_U3 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREPAIR_NUMBER
CS_REPAIRS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnRMA_HEADER_ID
CS_REPAIRS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPROMISED_DELIVERY_DATE
CS_REPAIRS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnESTIMATE_ID
CS_REPAIRS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnINCIDENT_ID
CS_REPAIRS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnDIAGNOSIS_ID
CS_REPAIRS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSTATUS
CS_REPAIRS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnRMA_LINE_ID
CS_REPAIRS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnWIP_ENTITY_ID
CS_REPAIRS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREPAIR_HEADER_ID
CS_REPAIRS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCUSTOMER_PRODUCT_ID
CS_REPAIRS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnINVENTORY_ITEM_ID
CS_REPAIRS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnRMA_CUSTOMER_ID
CS_REPAIRS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnRMA_NUMBER
ColumnRMA_LINE_NUMBER
CS_REPAIRS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnJOB_COMPLETION_DATE
Columns
Name Datatype Length Mandatory Comments
REPAIR_LINE_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
REPAIR_NUMBER VARCHAR2 (30)
PROGRAM_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

RMA_HEADER_ID NUMBER (15)
RMA_LINE_ID NUMBER (15)
RMA_CUSTOMER_ID NUMBER

RMA_NUMBER NUMBER

RMA_TYPE_ID NUMBER

RMA_DATE DATE

RMA_LINE_NUMBER NUMBER

REPAIR_DURATION NUMBER

RECEIVED_DATE DATE
Yes
MTL_TRANSACTION_ID NUMBER

SHIPPED_DATE DATE

ESTIMATE_ID NUMBER (15)
WIP_ENTITY_ID NUMBER (15)
GROUP_ID NUMBER

REPAIR_HEADER_ID NUMBER (15)
REPAIR_ORDER_LINE_ID NUMBER

REPLACE_HEADER_ID NUMBER (15)
LOANER_HEADER_ID NUMBER (15)
CUSTOMER_PRODUCT_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15) Yes
SERIAL_NUMBER VARCHAR2 (30)
QUANTITY_RECEIVED NUMBER
Yes
QUANTITY_COMPLETE NUMBER

QUANTITY_SCRAPPED NUMBER

QUANTITY_REPLACED NUMBER

REPAIR_UNIT_OF_MEASURE_CODE VARCHAR2 (3)
STATUS VARCHAR2 (30) Yes
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CONTEXT VARCHAR2 (30)
ORG_ID NUMBER

ORGANIZATION_ID NUMBER

RECVD_ORGANIZATION_ID NUMBER
Yes
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
ALLOW_JOB VARCHAR2 (1)
INCIDENT_ID NUMBER (15)
ESTIMATE_BUSINESS_GROUP_ID NUMBER (15)
DIAGNOSIS_ID NUMBER (15)
DIAGNOSED_BY_ID NUMBER (15)
JOB_COMPLETION_DATE DATE

PROMISED_DELIVERY_DATE DATE

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
Query Text

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


SELECT REPAIR_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      REPAIR_NUMBER
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      RMA_HEADER_ID
,      RMA_LINE_ID
,      RMA_CUSTOMER_ID
,      RMA_NUMBER
,      RMA_TYPE_ID
,      RMA_DATE
,      RMA_LINE_NUMBER
,      REPAIR_DURATION
,      RECEIVED_DATE
,      MTL_TRANSACTION_ID
,      SHIPPED_DATE
,      ESTIMATE_ID
,      WIP_ENTITY_ID
,      GROUP_ID
,      REPAIR_HEADER_ID
,      REPAIR_ORDER_LINE_ID
,      REPLACE_HEADER_ID
,      LOANER_HEADER_ID
,      CUSTOMER_PRODUCT_ID
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      QUANTITY_RECEIVED
,      QUANTITY_COMPLETE
,      QUANTITY_SCRAPPED
,      QUANTITY_REPLACED
,      REPAIR_UNIT_OF_MEASURE_CODE
,      STATUS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      ORG_ID
,      ORGANIZATION_ID
,      RECVD_ORGANIZATION_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      ALLOW_JOB
,      INCIDENT_ID
,      ESTIMATE_BUSINESS_GROUP_ID
,      DIAGNOSIS_ID
,      DIAGNOSED_BY_ID
,      JOB_COMPLETION_DATE
,      PROMISED_DELIVERY_DATE
,      PROJECT_ID
,      TASK_ID
FROM CS.CS_REPAIRS_ALL;

Dependencies

[top of page]

CS.CS_REPAIRS_ALL does not reference any database object

CS.CS_REPAIRS_ALL is referenced by following:

SchemaAPPS
SynonymCS_REPAIRS_ALL