[Home] [Help] [Dependency Information]

TABLE: CS.CS_REPAIRS_ALL

Object Details

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

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_REPAIRS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	REPAIR_LINE_ID
CS_REPAIRS_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ESTIMATE_BUSINESS_GROUP_ID
CS_REPAIRS_U3	NORMAL	UNIQUE	APPS_TS_ARCHIVE	REPAIR_NUMBER
CS_REPAIRS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_HEADER_ID
CS_REPAIRS_N10	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PROMISED_DELIVERY_DATE
CS_REPAIRS_N11	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ESTIMATE_ID
CS_REPAIRS_N12	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	INCIDENT_ID
CS_REPAIRS_N13	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	DIAGNOSIS_ID
CS_REPAIRS_N14	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	STATUS
CS_REPAIRS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_LINE_ID
CS_REPAIRS_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	WIP_ENTITY_ID
CS_REPAIRS_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REPAIR_HEADER_ID
CS_REPAIRS_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CUSTOMER_PRODUCT_ID
CS_REPAIRS_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	INVENTORY_ITEM_ID
CS_REPAIRS_N7	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_CUSTOMER_ID
CS_REPAIRS_N8	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_NUMBER RMA_LINE_NUMBER
CS_REPAIRS_N9	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	JOB_COMPLETION_DATE

Columns

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:

APPS

CS_REPAIRS_ALL