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_INTERORG_TXNS_TMP

Object Details

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

CST_PAC_INTERORG_TXNS_TMP is used by Iterative Periodic Average Cost Processor to store across Cost Group interorg transactions for a period fetched from MTL_MATERIAL_TRANSACTIONS table. The records in the table are cleared and repopulated when the processor is run using Start option. If the processor is run using Resume for non-tolerance then the table is not repopulated.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PAC_INTERORG_TXNS_TMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID COST_GROUP_ID PAC_PERIOD_ID TXN_TYPE
CST_PAC_INTERORG_TXNS_TMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_GROUP_ID PAC_PERIOD_ID INVENTORY_ITEM_ID TXN_TYPE
CST_PAC_INTERORG_TXNS_TMP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_GROUP_ID TRANSFER_COST_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction Id
COST_GROUP_ID	NUMBER		Yes	Cost Group Id
PAC_PERIOD_ID	NUMBER		Yes	Periodic Average Costing Period
TXN_TYPE	NUMBER		Yes	Transaction Type. One of Cost Owned (1), Cost Derived (2)
TRANSACTION_ACTION_ID	NUMBER		Yes	Transaction Action Id
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Yes	Transaction Source Type Id
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Id
PRIMARY_QUANTITY	NUMBER		Yes	Primary Quantity
PERIODIC_PRIMARY_QUANTITY	NUMBER			Periodic Primary Quantity
ORGANIZATION_ID	NUMBER		Yes	Organization Id
TRANSFER_ORGANIZATION_ID	NUMBER			Transfer Organization Id
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
TRANSFER_PRICE	NUMBER			Transfer Price
SHIPMENT_NUMBER	VARCHAR2	(30)		Shipment Number
TRANSFER_TRANSACTION_ID	NUMBER			Transfer Transaction Id
WAYBILL_AIRBILL	VARCHAR2	(20)		Airbill / waybill number
TRANSFER_COST	NUMBER			Transfer Cost
TRANSPORTATION_COST	NUMBER			Transportation Cost
TRANSFER_PERCENTAGE	NUMBER			Transfer Percentage
TRANSFER_COST_GROUP_ID	NUMBER			Transfer Cost Group Id

Query Text

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


SELECT TRANSACTION_ID
,      COST_GROUP_ID
,      PAC_PERIOD_ID
,      TXN_TYPE
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      INVENTORY_ITEM_ID
,      PRIMARY_QUANTITY
,      PERIODIC_PRIMARY_QUANTITY
,      ORGANIZATION_ID
,      TRANSFER_ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      TRANSFER_PRICE
,      SHIPMENT_NUMBER
,      TRANSFER_TRANSACTION_ID
,      WAYBILL_AIRBILL
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      TRANSFER_PERCENTAGE
,      TRANSFER_COST_GROUP_ID
FROM BOM.CST_PAC_INTERORG_TXNS_TMP;

Dependencies

[top of page]

BOM.CST_PAC_INTERORG_TXNS_TMP does not reference any database object

BOM.CST_PAC_INTERORG_TXNS_TMP is referenced by following:

BOM: CST_PAC_INTERORG_TXNS_TMP#