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: GMF.CM_BRDN_DTL

Object Details

Object Name:	CM_BRDN_DTL
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.CM_BRDN_DTL
Subobject Name:
Status:	VALID

Cost Burden Details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_BRDN_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BURDENLINE_ID
CM_BRDN_DTL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CMPNTCOST_ID
CM_BRDN_DTL_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID RESOURCES PERIOD_ID COST_TYPE_ID COST_CMPNTCLS_ID COST_ANALYSIS_CODE#1

Foreign Keys

Table		Foreign Table	Foreign Key Column
CM_BRDN_DTL		CM_CMPT_DTL	CM_BRDN_DTL CMPNTCOST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BURDENLINE_ID	NUMBER	(10)	Yes	Surrogate for this burden line. (also posted to cm_acst_led.transline_id by Actual Cost Process)
ORGN_CODE	VARCHAR2	(4)		Organization for the burden
WHSE_CODE	VARCHAR2	(4)		Warehouse
ITEM_ID	NUMBER	(10)		Surrogate for item
RESOURCES	VARCHAR2	(16)	Yes	Resource used for the burden cost
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar
PERIOD_CODE	VARCHAR2	(4)		Cost Period - specifies the start and end dates for the burden cost
COST_MTHD_CODE	VARCHAR2	(4)		Specific costing method that the burden cost will be applied under
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Surrogate for component class
BURDEN_QTY	NUMBER		Yes	Quantity of Burden used in calculating the burden cost
BURDEN_USAGE	NUMBER		Yes	Burden Usage - used in calculating the burden cost
BURDEN_UM	VARCHAR2	(4)		Burden uom used in calculating the burden cost
ITEM_QTY	NUMBER		Yes	Quantity of item used in calculating the burden cost
ITEM_UM	VARCHAR2	(4)		Item uom used in calculating the burden cost
BURDEN_FACTOR	NUMBER		Yes	Burden factor used in calculating the burden cost
ROLLOVER_IND	NUMBER	(5)		Indicates if the burden cost has been frozen or not - 0 = not frozen
CMPNTCOST_ID	NUMBER	(10)		Surrogate to cost component details
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
BURDEN_UOM	VARCHAR2	(3)		Resource usage unit of measure
COST_TYPE_ID	NUMBER	(15)		cost type identifier
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
ITEM_UOM	VARCHAR2	(3)		Item qty unit of measure
ORGANIZATION_ID	NUMBER	(15)		organization identifier
PERIOD_ID	NUMBER	(15)		period identifier
COST_ANALYSIS_CODE#1	VARCHAR2	(32)	Yes	COST ANALYSIS CODE #1

Query Text

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


SELECT BURDENLINE_ID
,      ORGN_CODE
,      WHSE_CODE
,      ITEM_ID
,      RESOURCES
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      BURDEN_QTY
,      BURDEN_USAGE
,      BURDEN_UM
,      ITEM_QTY
,      ITEM_UM
,      BURDEN_FACTOR
,      ROLLOVER_IND
,      CMPNTCOST_ID
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BURDEN_UOM
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ITEM_UOM
,      ORGANIZATION_ID
,      PERIOD_ID
,      COST_ANALYSIS_CODE#1
FROM GMF.CM_BRDN_DTL;

Dependencies

[top of page]

GMF.CM_BRDN_DTL does not reference any database object

GMF.CM_BRDN_DTL is referenced by following:

GMF: CM_BRDN_DTL#