[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
BOM.CST_PAC_INTERORG_TXNS_TMP does not reference any database object
BOM.CST_PAC_INTERORG_TXNS_TMP is referenced by following:
|
|
|