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: CS.CS_COST_DETAILS

Object Details

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

CS_COST_DETAILS stores details about Cost lines in Service. Cost lines can be created on behalf of a Service Request, a Depot Repair Order, or a Service/Debrief, but they will always have a parent Service Request.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_COST_DETAILS__U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ESTIMATE_DETAIL_ID
CS_COST_DETAILS__N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCIDENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COST_ID	NUMBER		Yes	Unique Identifier of the Cost Record
INCIDENT_ID	NUMBER		Yes	Service Request ID for which the Cost Record(s) is created
ESTIMATE_DETAIL_ID	NUMBER			Unique identifier for a charge line and for which the cost is created
TRANSACTION_TYPE_ID	NUMBER			Unique identifier for Transaction Types that control process of Charges/cost lines in Service.
TXN_BILLING_TYPE_ID	NUMBER			ID that identifies the billing type
INVENTORY_ITEM_ID	NUMBER			Item Id for which the cost is created
QUANTITY	NUMBER			Product Quantity
UNIT_COST	NUMBER			Item cost per quantity
EXTENDED_COST	NUMBER			Unit cost * Quantity
TRANSACTION_DATE	DATE			Date on which cost line was created
OVERRIDE_EXT_COST_FLAG	VARCHAR2	(3)		Flag to determine whether extended cost is overridden or not
SOURCE_ID	NUMBER		Yes	Current source ID for the cost line eg - Debrief, Depot Repair, Charges
SOURCE_CODE	VARCHAR2	(3)	Yes	Current Source Code for the cost line eg - Debrief, Depot Repair, Charges
UNIT_OF_MEASURE_CODE	VARCHAR2	(5)		UOM of the product
CURRENCY_CODE	VARCHAR2	(3)		Currency Code
ORG_ID	NUMBER			The Operating Unit of the Cost line. If null use the Operating Unit of the parent Service Request.
INVENTORY_ORG_ID	NUMBER			Transaction Inventory Organization (Warehouse)
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
OBJECT_VERSION_NUMBER	NUMBER			Object version number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
INTERFACED_TO_PA_FLAG	VARCHAR2	(1)		Indicates if the cost line is interfaced to Projects

Query Text

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


SELECT COST_ID
,      INCIDENT_ID
,      ESTIMATE_DETAIL_ID
,      TRANSACTION_TYPE_ID
,      TXN_BILLING_TYPE_ID
,      INVENTORY_ITEM_ID
,      QUANTITY
,      UNIT_COST
,      EXTENDED_COST
,      TRANSACTION_DATE
,      OVERRIDE_EXT_COST_FLAG
,      SOURCE_ID
,      SOURCE_CODE
,      UNIT_OF_MEASURE_CODE
,      CURRENCY_CODE
,      ORG_ID
,      INVENTORY_ORG_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      INTERFACED_TO_PA_FLAG
FROM CS.CS_COST_DETAILS;

Dependencies

[top of page]

CS.CS_COST_DETAILS does not reference any database object

CS.CS_COST_DETAILS is referenced by following:

CS: CS_COST_DETAILS#