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: BOM.CST_PAC_INTORG_ITMS_TEMP

Object Details

Object Name:	CST_PAC_INTORG_ITMS_TEMP
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_PAC_INTORG_ITMS_TEMP
Subobject Name:
Status:	VALID

CST_PAC_INTORG_ITMS_TEMP is used in the interorg transfer iteration process of Periodic Absorption Cost Processor

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PAC_INTORG_ITMS_TEMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAC_PERIOD_ID COST_GROUP_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Identifier
COST_GROUP_ID	NUMBER		Yes	Cost Group Identifier
PAC_PERIOD_ID	NUMBER		Yes	PAC Period Identifier
ITEM_COST	NUMBER			Item Cost
LOW_LEVEL_CODE	NUMBER			Low Level Code of Inventory Item specific to cost group
ABSORPTION_LEVEL_CODE	NUMBER			Bill of Materials Level to which item is absorbed
TOLERANCE_FLAG	VARCHAR2	(1)		Tolerance Flag
ITERATION_COUNT	NUMBER			Iteration Count
PREV_ITR_ITEM_COST	NUMBER			Previous iteration PMAC Item Cost
INTERORG_RECEIPT_FLAG	VARCHAR2	(1)		Interorg Receipt Flag used in iteration process
INTERORG_SHIPMENT_FLAG	VARCHAR2	(1)		Interorg Shipment Flag used in Iteration Process of PACP
SEQUENCE_NUM	NUMBER			Optimal Sequence of Cost Group in Iteration Process
DIFFERENCE	NUMBER			Difference between current and previous iteration item cost
DIVERGING_FLAG	VARCHAR2	(1)		Diverging Flag

Query Text

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


SELECT INVENTORY_ITEM_ID
,      COST_GROUP_ID
,      PAC_PERIOD_ID
,      ITEM_COST
,      LOW_LEVEL_CODE
,      ABSORPTION_LEVEL_CODE
,      TOLERANCE_FLAG
,      ITERATION_COUNT
,      PREV_ITR_ITEM_COST
,      INTERORG_RECEIPT_FLAG
,      INTERORG_SHIPMENT_FLAG
,      SEQUENCE_NUM
,      DIFFERENCE
,      DIVERGING_FLAG
FROM BOM.CST_PAC_INTORG_ITMS_TEMP;

Dependencies

[top of page]

BOM.CST_PAC_INTORG_ITMS_TEMP does not reference any database object

BOM.CST_PAC_INTORG_ITMS_TEMP is referenced by following:

BOM: CST_PAC_INTORG_ITMS_TEMP#