DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_PAC_TXN_COST_DETAILS

Object Details
Object Name: MTL_PAC_TXN_COST_DETAILS
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_PAC_TXN_COST_DETAILS
Subobject Name:
Status: VALID


MTL_PAC_TXN_COST_DETAILS stores the cost of a transaction by element and level for the period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_PAC_TXN_COST_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
ColumnPAC_PERIOD_ID
ColumnCOST_GROUP_ID
ColumnCOST_ELEMENT_ID
ColumnLEVEL_TYPE
MTL_PAC_TXN_COST_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAC_PERIOD_ID
ColumnCOST_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
COST_GROUP_ID NUMBER
Yes Cost group identifier
TRANSACTION_ID NUMBER
Yes Transaction identifier
PAC_PERIOD_ID NUMBER
Yes Period identifier
COST_TYPE_ID NUMBER
Yes Cost type identifier
COST_ELEMENT_ID NUMBER
Yes Cost element identifier
LEVEL_TYPE NUMBER
Yes Level type - this or previous
INVENTORY_ITEM_ID NUMBER
Yes Item identifier
TRANSACTION_COST NUMBER

Cost of transaction
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
REQUEST_ID NUMBER

Extended Who column
PROGRAM_APPLICATION_ID NUMBER

Extended Who column
PROGRAM_ID NUMBER

Extended Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
NEW_PERIODIC_COST NUMBER

New periodic cost, used only for periodic costing
PERCENTAGE_CHANGE NUMBER

Percentage change in periodic cost
VALUE_CHANGE NUMBER

Change in value of periodic item cost
WIP_VARIANCE NUMBER

Variance for WIP related Inventory transaction originating from BOM based WIP requirements
Query Text

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


SELECT COST_GROUP_ID
,      TRANSACTION_ID
,      PAC_PERIOD_ID
,      COST_TYPE_ID
,      COST_ELEMENT_ID
,      LEVEL_TYPE
,      INVENTORY_ITEM_ID
,      TRANSACTION_COST
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NEW_PERIODIC_COST
,      PERCENTAGE_CHANGE
,      VALUE_CHANGE
,      WIP_VARIANCE
FROM INV.MTL_PAC_TXN_COST_DETAILS;

Dependencies

[top of page]

INV.MTL_PAC_TXN_COST_DETAILS does not reference any database object

INV.MTL_PAC_TXN_COST_DETAILS is referenced by following:

SchemaINV
ViewMTL_PAC_TXN_COST_DETAILS#