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_TYPES_B

Object Details

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

This table stores all the repair types. User can associate Workflow to the repair type.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSD_REPAIR_TYPES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	REPAIR_TYPE_ID ZD_EDITION_NAME
CSD_REPAIR_TYPES_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	WORKFLOW_ITEM_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
REPAIR_TYPE_ID	NUMBER	(15)	Yes	Unique repair type identifier
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).
WORKFLOW_ITEM_TYPE	VARCHAR2	(8)		Workflow item type associated with the repair type
START_DATE_ACTIVE	DATE			Date the repair type becomes active
END_DATE_ACTIVE	DATE			Date the repair type becomes inactive
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
AUTO_PROCESS_RMA	VARCHAR2	(1)		Flag to indicate whether or not to process an RMA automatically for this Repair Type.
INTERFACE_TO_OM_FLAG	VARCHAR2	(1)		Flag to indicate whether to interface the charge line to Order Management or not.
BOOK_SALES_ORDER_FLAG	VARCHAR2	(1)		Flag to indicate whether or not to Book the Sales Order created earlier.
RELEASE_SALES_ORDER_FLAG	VARCHAR2	(1)		Flag to indicate whether or not to Pick Release the Sales Order booked earlier.
SHIP_SALES_ORDER_FLAG	VARCHAR2	(1)		Flag to indicate whether or not to Ship Confirm the Sales Order released earlier.
REPAIR_TYPE_REF	VARCHAR2	(30)		Reference repair type - To link Custom defined repair types to the Seeded ones. Seeded values are from FND lookup CSD_REPAIR_TYPES.
REPAIR_MODE	VARCHAR2	(30)		Repair Mode chosen for this repair Order - WIP orTask.
SEEDED_FLAG	VARCHAR2	(1)		Flag to indicate whether the repair type is seeded or not.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
BUSINESS_PROCESS_ID	NUMBER	(15)		Default Business Process Id for the estimate details for this repair type.
PRICE_LIST_HEADER_ID	NUMBER	(15)		Default Price list header Id for the estimate details for the repair type.
CPS_TXN_BILLING_TYPE_ID	NUMBER	(15)		Default Service Transaction Billing Type for the Customer Product ship in estimate details.
CPR_TXN_BILLING_TYPE_ID	NUMBER	(15)		Default Service Transaction Billing Type for the Customer Product RMA in estimate details.
LS_TXN_BILLING_TYPE_ID	NUMBER	(15)		Default Service Transaction Billing Type for the Loaner ship in estimate details.
LR_TXN_BILLING_TYPE_ID	NUMBER	(15)		Default Service Transaction Billing Type for the Loaner RMA in estimate details.
MTL_TXN_BILLING_TYPE_ID	NUMBER			Default Service Transaction Billing Type for the material lines in estimate details.
LBR_TXN_BILLING_TYPE_ID	NUMBER			Default Service Transaction Billing Type for the labor lines in estimate details.
EXP_TXN_BILLING_TYPE_ID	NUMBER			Default Service Transaction Billing Type for the expense lines in estimate details.
INTERNAL_ORDER_FLAG	VARCHAR2	(1)		To identify if the repair type is internal repair type or not.
START_FLOW_STATUS_ID	NUMBER			The start status for the repair type.
THIRD_RMA_TXN_BILLING_TYPE_ID	NUMBER	(15)		Default Service Transaction Billing Type for 3rd party RMA
THIRD_SHIP_TXN_BILLING_TYPE_ID	NUMBER	(15)		Default Service Transaction Billing Type for 3nd Party Ship
THIRD_PARTY_FLAG	VARCHAR2	(1)		To identify if the repair type is 3rd party transaction or not.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes
RES_DT_CALC_POINT	VARCHAR2	(30)		Specifies when the resolve by date should be calculated.

Query Text

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


SELECT REPAIR_TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      WORKFLOW_ITEM_TYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      AUTO_PROCESS_RMA
,      INTERFACE_TO_OM_FLAG
,      BOOK_SALES_ORDER_FLAG
,      RELEASE_SALES_ORDER_FLAG
,      SHIP_SALES_ORDER_FLAG
,      REPAIR_TYPE_REF
,      REPAIR_MODE
,      SEEDED_FLAG
,      OBJECT_VERSION_NUMBER
,      BUSINESS_PROCESS_ID
,      PRICE_LIST_HEADER_ID
,      CPS_TXN_BILLING_TYPE_ID
,      CPR_TXN_BILLING_TYPE_ID
,      LS_TXN_BILLING_TYPE_ID
,      LR_TXN_BILLING_TYPE_ID
,      MTL_TXN_BILLING_TYPE_ID
,      LBR_TXN_BILLING_TYPE_ID
,      EXP_TXN_BILLING_TYPE_ID
,      INTERNAL_ORDER_FLAG
,      START_FLOW_STATUS_ID
,      THIRD_RMA_TXN_BILLING_TYPE_ID
,      THIRD_SHIP_TXN_BILLING_TYPE_ID
,      THIRD_PARTY_FLAG
,      ZD_EDITION_NAME
,      RES_DT_CALC_POINT
FROM CSD.CSD_REPAIR_TYPES_B;

Dependencies

[top of page]

CSD.CSD_REPAIR_TYPES_B does not reference any database object

CSD.CSD_REPAIR_TYPES_B is referenced by following:

CSD: CSD_REPAIR_TYPES_B#