eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CSD.CSD_REPAIRS

Object Details

Object Name:	CSD_REPAIRS
Object Type:	TABLE
Owner:	CSD
FND Design Data:	CSD.CSD_REPAIRS
Subobject Name:
Status:	VALID

This table holds all the repair orders. Now in 11i, Service Request is mandatory to create a repair order. CSD_REPAIRS is not stripped by ORG_ID as the parent CS_INCIDENTS_ALL_B is already stripped by ORG_ID. CUSTOMER_PRODUCT_ID identifies the customer product in the installed base, if the installed base has information about the item when it was originally shipped out to the customer. This information can be used during the estimation process to take into account any special services which the customer may have purchased.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSD_REPAIRS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPAIR_LINE_ID
CSD_REPAIRS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPAIR_NUMBER
CSD_REPAIRS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_LINE_ID
CSD_REPAIRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCIDENT_ID
CSD_REPAIRS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_PRODUCT_ID
CSD_REPAIRS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID
CSD_REPAIRS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID
CSD_REPAIRS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPAIR_TYPE_ID
CSD_REPAIRS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
CSD_REPAIRS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPROVAL_STATUS
CSD_REPAIRS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERIAL_NUMBER
CSD_REPAIRS_TU1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("REPAIR_NUMBER")

Columns

Name	Datatype	Length	Mandatory	Comments
REPAIR_LINE_ID	NUMBER	(15)	Yes	Unique repair order identifier
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REPAIR_NUMBER	VARCHAR2	(30)	Yes	Unique number for the repair order
INCIDENT_ID	NUMBER	(15)	Yes	Service request identifier - foreign key from CS_INCIDENTS_ALL_B
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Inventory item identifier - foreign key from MTL_SYSTEM_ITEMS_B
CUSTOMER_PRODUCT_ID	NUMBER	(15)		Installed base customer product identifier - foreign key from CS_CUSTOMER_PRODUCTS_ALL
UNIT_OF_MEASURE	VARCHAR2	(3)	Yes	Unit of Measure for the quantity field - foreign key from MTL_UNITS_OF_MEASURE_TL
REPAIR_TYPE_ID	NUMBER	(15)		Repair type identifier - foreign key from CSD_REPAIR_TYPES_B
RESOURCE_ID	NUMBER	(15)		Owner of the repair identifier - foreign key from JTF_RS_RESOURCE_EXTNS
INSTANCE_ID	NUMBER	(15)		Workflow instance identifier
PROJECT_ID	NUMBER	(15)		Project identifier
TASK_ID	NUMBER	(15)		Task identifier
CONTRACT_LINE_ID	NUMBER			Contract line identifier - foreign key from OKC_K_LINES_B
QUANTITY	NUMBER	(15)	Yes	Ordered quantity
STATUS	VARCHAR2	(30)	Yes	Status code of the repair
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag indicating that customer approval is required for the repair.
DATE_CLOSED	DATE			Date when the repair order is closed.
QUANTITY_IN_WIP	NUMBER	(15)		Total quantity in the WIP for the repair order
APPROVAL_STATUS	VARCHAR2	(30)		Status code of the customer approval
QUANTITY_RCVD	NUMBER	(15)		Total quantity received for the repair order
QUANTITY_SHIPPED	NUMBER	(15)		Total quantity shipped for the repair order
SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the item coming for repair
PROMISE_DATE	DATE			Promise date of delivery of the repaired broken product.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ORDER_LINE_ID	NUMBER			Currently not in use.
ORIGINAL_SOURCE_REFERENCE	VARCHAR2	(30)		Currently not in use.
STATUS_REASON_CODE	VARCHAR2	(30)		Reason for Approval or Rejection. Values from FND lookups - CSD_REASON or CSD_REJECT_REASON.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
AUTO_PROCESS_RMA	VARCHAR2	(1)		Auto Process RMA Flag. Flag indicator to say whether or not to process an RMA automatically for this Repair Type.
REPAIR_MODE	VARCHAR2	(30)		Repair Mode chosen for this repair Order. Can be either WIP or Task.
ITEM_REVISION	VARCHAR2	(3)		Item revsion code from Inventory. Only used if the item is revsion controlled.
REPAIR_GROUP_ID	NUMBER			Foreign key to CSD_REPAIR_ORDER_GROUPS table. It is used only when the repair order is created for a mass repair orders.
RO_TXN_STATUS	VARCHAR2	(30)		Status for the repair order lifecycle.
CURRENCY_CODE	VARCHAR2	(15)		Repair order currency.
DEFAULT_PO_NUM	VARCHAR2	(80)		Default PO Number
ORIGINAL_SOURCE_HEADER_ID	NUMBER			Header Id of the Source of the repair order creation.
ORIGINAL_SOURCE_LINE_ID	NUMBER			Line Id of the Source of the repair order creation.
SPLIT_FROM_REP_LINE_ID	NUMBER			The column is to store the original repair line id.
SPLIT_FLAG	VARCHAR2	(1)		To identify if the repair type is internal repari type or not.
PRICE_LIST_HEADER_ID	NUMBER			The price list header id for the Repair order.
SUPERCESSION_INV_ITEM_ID	NUMBER			Inventory item id for upgraded product.
OWNING_ORGANIZATION	NUMBER			Organization that owns the Repair Order. (Obsoleted)
UNIT_NUMBER	VARCHAR2	(30)		Unit Number
OWNING_ORGANIZATION_ID	NUMBER			Organization that owns the Repair Order.
PROBLEM_DESCRIPTION	VARCHAR2	(240)		Description of the problem that the customer has with the Repair Order item
FLOW_STATUS_ID	NUMBER			Flow Status identifier.
WF_ITEM_TYPE	VARCHAR2	(8)		Workflow Item Type.
WF_ITEM_KEY	VARCHAR2	(240)		Workflow Item Key.
INVENTORY_ORG_ID	NUMBER			Inventory Organization Id
RO_PRIORITY_CODE	VARCHAR2	(30)		Repair Order Priority
RESOLVE_BY_DATE	DATE			Resolve By Date: Defaulted from default contract.
ESCALATION_CODE	VARCHAR2	(30)		Escalated Code
IN_WARRANTY_CODE	VARCHAR2	(30)		In Warranty Code
WARRANTY_VIOLATION_CODE	VARCHAR2	(30)		Warranty Violation Code
REWORK_CODE	VARCHAR2	(30)		Rework Code
BULLETIN_CHECK_DATE	DATE			Bulletin Check Date
REPAIR_YIELD_QUANTITY	NUMBER	(15)		Supercession Quantity for APS integraion
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield segment
RO_WARRANTY_STATUS_CODE	VARCHAR2	(30)		Repair Order Warranty Status
RETURN_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Returns DFF Context
RETURN_ATTRIBUTE1	VARCHAR2	(150)		Returns DFF Segment
RETURN_ATTRIBUTE2	VARCHAR2	(150)		Returns DFF Segment
RETURN_ATTRIBUTE3	VARCHAR2	(150)		Returns DFF Segment
RETURN_ATTRIBUTE4	VARCHAR2	(150)		Returns DFF Segment
RETURN_ATTRIBUTE5	VARCHAR2	(150)		Returns DFF Segment
RETURN_ATTRIBUTE6	VARCHAR2	(150)		Returns DFF Segment
RETURN_ATTRIBUTE7	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE8	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE9	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE10	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE11	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE12	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE13	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE14	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE15	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE16	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE17	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE18	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE19	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE20	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE21	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE22	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE23	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE24	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE25	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE26	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE27	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE28	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE29	VARCHAR2	(150)		Return DFF Segment
RETURN_ATTRIBUTE30	VARCHAR2	(150)		Return DFF Segment
WAYBILL_NO	VARCHAR2	(30)		Waybill number.
RETURN_TYPE_ID	NUMBER			Return type associated with this repair order
PARENT_REPAIR_LINE_ID	NUMBER	(15)		Repair_line_id for parent repair order.

Query Text

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


SELECT REPAIR_LINE_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REPAIR_NUMBER
,      INCIDENT_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_PRODUCT_ID
,      UNIT_OF_MEASURE
,      REPAIR_TYPE_ID
,      RESOURCE_ID
,      INSTANCE_ID
,      PROJECT_ID
,      TASK_ID
,      CONTRACT_LINE_ID
,      QUANTITY
,      STATUS
,      APPROVAL_REQUIRED_FLAG
,      DATE_CLOSED
,      QUANTITY_IN_WIP
,      APPROVAL_STATUS
,      QUANTITY_RCVD
,      QUANTITY_SHIPPED
,      SERIAL_NUMBER
,      PROMISE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      ORDER_LINE_ID
,      ORIGINAL_SOURCE_REFERENCE
,      STATUS_REASON_CODE
,      OBJECT_VERSION_NUMBER
,      AUTO_PROCESS_RMA
,      REPAIR_MODE
,      ITEM_REVISION
,      REPAIR_GROUP_ID
,      RO_TXN_STATUS
,      CURRENCY_CODE
,      DEFAULT_PO_NUM
,      ORIGINAL_SOURCE_HEADER_ID
,      ORIGINAL_SOURCE_LINE_ID
,      SPLIT_FROM_REP_LINE_ID
,      SPLIT_FLAG
,      PRICE_LIST_HEADER_ID
,      SUPERCESSION_INV_ITEM_ID
,      OWNING_ORGANIZATION
,      UNIT_NUMBER
,      OWNING_ORGANIZATION_ID
,      PROBLEM_DESCRIPTION
,      FLOW_STATUS_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      INVENTORY_ORG_ID
,      RO_PRIORITY_CODE
,      RESOLVE_BY_DATE
,      ESCALATION_CODE
,      IN_WARRANTY_CODE
,      WARRANTY_VIOLATION_CODE
,      REWORK_CODE
,      BULLETIN_CHECK_DATE
,      REPAIR_YIELD_QUANTITY
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      RO_WARRANTY_STATUS_CODE
,      RETURN_ATTRIBUTE_CATEGORY
,      RETURN_ATTRIBUTE1
,      RETURN_ATTRIBUTE2
,      RETURN_ATTRIBUTE3
,      RETURN_ATTRIBUTE4
,      RETURN_ATTRIBUTE5
,      RETURN_ATTRIBUTE6
,      RETURN_ATTRIBUTE7
,      RETURN_ATTRIBUTE8
,      RETURN_ATTRIBUTE9
,      RETURN_ATTRIBUTE10
,      RETURN_ATTRIBUTE11
,      RETURN_ATTRIBUTE12
,      RETURN_ATTRIBUTE13
,      RETURN_ATTRIBUTE14
,      RETURN_ATTRIBUTE15
,      RETURN_ATTRIBUTE16
,      RETURN_ATTRIBUTE17
,      RETURN_ATTRIBUTE18
,      RETURN_ATTRIBUTE19
,      RETURN_ATTRIBUTE20
,      RETURN_ATTRIBUTE21
,      RETURN_ATTRIBUTE22
,      RETURN_ATTRIBUTE23
,      RETURN_ATTRIBUTE24
,      RETURN_ATTRIBUTE25
,      RETURN_ATTRIBUTE26
,      RETURN_ATTRIBUTE27
,      RETURN_ATTRIBUTE28
,      RETURN_ATTRIBUTE29
,      RETURN_ATTRIBUTE30
,      WAYBILL_NO
,      RETURN_TYPE_ID
,      PARENT_REPAIR_LINE_ID
FROM CSD.CSD_REPAIRS;

Dependencies

[top of page]

CSD.CSD_REPAIRS does not reference any database object

CSD.CSD_REPAIRS is referenced by following:

CSD: CSD_REPAIRS#