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

TABLE: BOM.CST_PAC_ITMS_ABSL_CODES

Object Details
Object Name: CST_PAC_ITMS_ABSL_CODES
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_PAC_ITMS_ABSL_CODES
Subobject Name:
Status: VALID


CST_PAC_ITMS_ABSL_CODES is used in the Absorption Cost Rollup process of Periodic Absorption Cost Processor
Table contains Absorption Hierarchy Level Code for each inventory item in a given pac period.
Absorption Hierarchy Level Code is used to retrieve the items inorder to process the PAC transactions to make sure that the cost of the assembled items are completely absorbed with the rollup costs from all of its child items.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_PAC_ITMS_ABSL_CODES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAC_PERIOD_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
PAC_PERIOD_ID NUMBER
Yes PAC Period Identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
ABSORPTION_LEVEL_CODE NUMBER
Yes Absorption Level Code used in Absorption Cost Rollup Process
PROCESS_FLAG VARCHAR2 (1)
Process Flag to identify whether an item is processed or not
Query Text

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


SELECT PAC_PERIOD_ID
,      INVENTORY_ITEM_ID
,      ABSORPTION_LEVEL_CODE
,      PROCESS_FLAG
FROM BOM.CST_PAC_ITMS_ABSL_CODES;

Dependencies

[top of page]

BOM.CST_PAC_ITMS_ABSL_CODES does not reference any database object

BOM.CST_PAC_ITMS_ABSL_CODES is referenced by following:

SchemaAPPS
SynonymCST_PAC_ITMS_ABSL_CODES