[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CST_PM_MATL_TXNS_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | BOM |
| FND Design Data: |  BOM.CST_PM_MATL_TXNS_TEMP
|
| Subobject Name: | |
| Status: | VALID |
Temporary table for use by Cost Collection Manager Concurrent program
BOM.CST_PM_MATL_TXNS_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | Transaction Id | ||
| ORGANIZATION_ID | NUMBER | Organization Id | ||
| TRANSACTION_ACTION_ID | NUMBER | Transaction Action Id | ||
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction Source Type Id | ||
| TYPE_CLASS | NUMBER | Class Type | ||
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Project Expenditure Type | |
| TRANSACTION_DATE | DATE | Transaction Date | ||
| PROJECT_ID | NUMBER | Project Id | ||
| TASK_ID | NUMBER | Task Id | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
| PRIMARY_QUANTITY | NUMBER | Primary Quantity | ||
| COSTED_FLAG | VARCHAR2 | (1) | Costed Flag | |
| PRIMARY_COST_METHOD | NUMBER | Primary Cost Method | ||
| AVG_RATES_COST_TYPE_ID | NUMBER | Average RatesCost Type Id | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
| COST_GROUP_ID | NUMBER | Cost Group Id | ||
| TRANSFER_COST_GROUP_ID | NUMBER | Transfer Cost Group Id | ||
| TRANSACTION_SOURCE_ID | NUMBER | Transaction Source Id | ||
| TO_PROJECT_ID | NUMBER | TO Project Id | ||
| TO_TASK_ID | NUMBER | TO Task Id | ||
| SOURCE_PROJECT_ID | NUMBER | Source Project Id | ||
| SOURCE_TASK_ID | NUMBER | Source Task Id | ||
| TRANSFER_TRANSACTION_ID | NUMBER | Transfer Transaction Id | ||
| ACCT_PERIOD_ID | NUMBER | Accounting Period Id | ||
| EXP_ORG_ID | NUMBER | Expenditure Organization Id | ||
| DISTRIBUTION_ACCOUNT_ID | NUMBER | Distribution Account Id | ||
| PM_COST_COLLECTOR_GROUP_ID | NUMBER | Cost Collection Group Id | ||
| SI_ASSET_YES_NO | NUMBER | Asset Subinventory or not | ||
| TRANSFER_SI_ASSET_YES_NO | NUMBER | Transfer transactions subinventory is asset or not | ||
| PM_COST_COLLECTED | VARCHAR2 | (1) | Flag to indicate whether the transaction has been cost collected | |
| SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory Code | |
| TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | Transfer transaction subinventory code | |
| TRANSFER_ORGANIZATION_ID | NUMBER | Transfer Transaction Organization Id | ||
| INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Flag to indicate Asset Item | |
| FLOW_SCHEDULE | VARCHAR2 | (1) | Flow Schedule Transaction |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, ORGANIZATION_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID
, TYPE_CLASS
, EXPENDITURE_TYPE
, TRANSACTION_DATE
, PROJECT_ID
, TASK_ID
, INVENTORY_ITEM_ID
, PRIMARY_QUANTITY
, COSTED_FLAG
, PRIMARY_COST_METHOD
, AVG_RATES_COST_TYPE_ID
, ITEM_DESCRIPTION
, COST_GROUP_ID
, TRANSFER_COST_GROUP_ID
, TRANSACTION_SOURCE_ID
, TO_PROJECT_ID
, TO_TASK_ID
, SOURCE_PROJECT_ID
, SOURCE_TASK_ID
, TRANSFER_TRANSACTION_ID
, ACCT_PERIOD_ID
, EXP_ORG_ID
, DISTRIBUTION_ACCOUNT_ID
, PM_COST_COLLECTOR_GROUP_ID
, SI_ASSET_YES_NO
, TRANSFER_SI_ASSET_YES_NO
, PM_COST_COLLECTED
, SUBINVENTORY_CODE
, TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION_ID
, INVENTORY_ASSET_FLAG
, FLOW_SCHEDULE
FROM BOM.CST_PM_MATL_TXNS_TEMP;
BOM.CST_PM_MATL_TXNS_TEMP does not reference any database object
BOM.CST_PM_MATL_TXNS_TEMP is referenced by following:
APPS
CST_PM_MATL_TXNS_TEMP
|
|
|
|