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_REPAIR_ORDER_GROUPS

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSD_REPAIR_ORDER_GROUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPAIR_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPAIR_GROUP_ID	NUMBER		Yes	Unique identifier for the table.
INCIDENT_ID	NUMBER		Yes	Service Request reference. Foreign key to CSD_INCIDENTS_ALL.
REPAIR_GROUP_NUMBER	VARCHAR2	(30)	Yes	Unique number for the repair order group. Used for display.
REPAIR_TYPE_ID	NUMBER			Indicates the repair type associated to the repair order group. Foreign key to CSD_REPAIR_TYPES_B.
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier. Foreign key to MTL_SYSTEM_ITEMS_B.
UNIT_OF_MEASURE	VARCHAR2	(3)		Foreign key to MTL_UNIT_OF_MEASURE_TL.
GROUP_QUANTITY	NUMBER			Number of items for which the repair order group is created.
REPAIR_ORDER_QUANTITY	NUMBER			Number of repair order lines created for the group.
RMA_QUANTITY	NUMBER			Number of units of the item for which RMAs are created.
RECEIVED_QUANTITY	NUMBER			Quantity received against RMAs.
APPROVED_QUANTITY	NUMBER			Number of repair orders approved.
SUBMITTED_QUANTITY	NUMBER			Quantity submitted for the WIP job.
COMPLETED_QUANTITY	NUMBER			Quantity completed by the WIP job.
RELEASED_QUANTITY	NUMBER			Quantity of the item Pick Released for the Sales Order.
SHIPPED_QUANTITY	NUMBER			Quantity of the item Shipped for the Sales Order.
CREATED_BY	NUMBER		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		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		Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CONTEXT	VARCHAR2	(240)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(100)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(100)		Descriptive flexfield segment
SECURITY_GROUP_ID	NUMBER			Used in hosted environments.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
GROUP_TXN_STATUS	VARCHAR2	(30)		Transaction status for the group lifecycle. Valid values are from FND lookup CSD_GROUP_TXN_STATUS.
WIP_ENTITY_ID	NUMBER			Identifier for the job created for the group. Foreign key to the WIP_DISCRETE_JOBS.
GROUP_APPROVAL_STATUS	VARCHAR2	(30)		Approval status for the group. Derived to be 'APPROVED', if all the repair orders have the status as 'APPROVED'.
REPAIR_MODE	VARCHAR2	(30)		Mode in which the repair job is performed. Could be either WIP or TASK.

Query Text

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


SELECT REPAIR_GROUP_ID
,      INCIDENT_ID
,      REPAIR_GROUP_NUMBER
,      REPAIR_TYPE_ID
,      INVENTORY_ITEM_ID
,      UNIT_OF_MEASURE
,      GROUP_QUANTITY
,      REPAIR_ORDER_QUANTITY
,      RMA_QUANTITY
,      RECEIVED_QUANTITY
,      APPROVED_QUANTITY
,      SUBMITTED_QUANTITY
,      COMPLETED_QUANTITY
,      RELEASED_QUANTITY
,      SHIPPED_QUANTITY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      GROUP_TXN_STATUS
,      WIP_ENTITY_ID
,      GROUP_APPROVAL_STATUS
,      REPAIR_MODE
FROM CSD.CSD_REPAIR_ORDER_GROUPS;

Dependencies

[top of page]

CSD.CSD_REPAIR_ORDER_GROUPS does not reference any database object

CSD.CSD_REPAIR_ORDER_GROUPS is referenced by following:

CSD: CSD_REPAIR_ORDER_GROUPS#