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_ACST_LED

Object Details

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

The purpose of this table is to serve as a depository of all actual
costing transactions. These transactions may originate from
Production Batch details (pm_matl_dtl) or POC resource details
(pm_oprn_dtl) or Purchase order rece

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_ACST_LED_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTRANS_ID
CM_ACST_LEDI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CMPNTCOST_ID
CM_ACST_LED_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_IND TRANSLINE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CM_ACST_LED		CM_CMPT_DTL	CM_ACST_LED CMPNTCOST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTRANS_ID	NUMBER	(10)	Yes	Surrogate for this ledger transaction row
WHSE_CODE	VARCHAR2	(4)		specific warehouse for the cost
CALENDAR_CODE	VARCHAR2	(4)		Cost Calendar defined for the transaction based on dates
PERIOD_CODE	VARCHAR2	(4)		Costing Period (of the cost calendar) defined for the transaction based on dates
COST_MTHD_CODE	VARCHAR2	(4)		Actual cost method code used
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	component class surrogate
COST_ANALYSIS_CODE	VARCHAR2	(4)	Yes	cost analysis code
TRANSLINE_ID	NUMBER	(10)	Yes	Surrogate of source transaction: pm_matl_dtl.line_id, pm_oprn_dtl.batchstepline_id, po_recv_dtl.recv_line_id, cm_brdn_dtl.burdenline_id
SOURCE_IND	NUMBER	(5)	Yes	0 - PM Batch details, 1 - POC Resource costs,..2 - CM Actual Burden costs, 3 - PO Receipts,..4 - GL Expense allocations, 5 - Adjustments, 6 - AP Interface
TRANS_DATE	DATE		Yes	Transaction date
ITEM_ID	NUMBER	(10)		surrogate for item
COST_AMT	NUMBER		Yes	actual cost for the transaction
TRANS_QTY	NUMBER		Yes	Quantity of the transaction. pm_matl_dtl.item_qty, po_recv_hst.net_qty
CMPNTCOST_ID	NUMBER	(10)	Yes	Surrogate to component detail - cm_cmpt_dtl.cmpntcost_id - for a quick access join. Also indicates if actual cost has been converted to CDA
ACPROC_ID	NUMBER	(10)	Yes	Surrogate to the specific actual costing process(reference number) that calculated this cost
ALLOC_PCT	NUMBER			Allocation percentage used to calculate the cost during GL expense allocations
TTL_ALLOC_EXPENSE	NUMBER			Total Allocation expense calculated during GL expense allocations
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
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_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		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
COST_TYPE_ID	NUMBER	(15)		cost type identifier
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item identifier
ORGANIZATION_ID	NUMBER	(15)		organization identifier
PERIOD_ID	NUMBER	(15)		period identifier
POST_TO_SUBLEDGER	NUMBER			Flag to indicate if transaction has to be booked to subledger
PROD_LAYER_ID	NUMBER			Product Layer Identifier for the batch output
PROD_LAYER_QTY	NUMBER			Product Layer Qty for the batch output
COST_LEVEL	NUMBER			Cost Level: 0 = This Level; 1 = Lower Level

Query Text

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


SELECT ACTRANS_ID
,      WHSE_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      TRANSLINE_ID
,      SOURCE_IND
,      TRANS_DATE
,      ITEM_ID
,      COST_AMT
,      TRANS_QTY
,      CMPNTCOST_ID
,      ACPROC_ID
,      ALLOC_PCT
,      TTL_ALLOC_EXPENSE
,      DELETE_MARK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_ID
,      POST_TO_SUBLEDGER
,      PROD_LAYER_ID
,      PROD_LAYER_QTY
,      COST_LEVEL
FROM GMF.CM_ACST_LED;

Dependencies

[top of page]

GMF.CM_ACST_LED does not reference any database object

GMF.CM_ACST_LED is referenced by following:

APPS: CM_ACST_LED