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]

VIEW: APPS.CST_PM_MATL_TXN_V

Object Details

Object Name:	CST_PM_MATL_TXN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_PM_MATL_TXN_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
TRANSACTION_ID	NUMBER		transaction id of the transaction
ORGANIZATION_ID	NUMBER		Organization Identifier
TRANSACTION_ACTION_ID	NUMBER		Determines the action for a given transaction
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Detemines the transaction's source type
TYPE_CLASS	NUMBER		Class of the Transaction Type for a transaction
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure Type of the transaction. Is Populated only for Capital Project Txn.
TRANSACTION_DATE	DATE		Date on which the transaction was made
PROJECT_ID	NUMBER	(15)	project to which locator of the transaction refers to
TASK_ID	NUMBER	(15)	Task assigned or to which the locator the transaction refers to
INVENTORY_ITEM_ID	NUMBER		Item the transaction refers to
PRIMARY_QUANTITY	NUMBER		quantity the transaction refers to
COSTED_FLAG	VARCHAR2	(1)	Flag to indicate whether or not the transaction was cost processed
PRIMARY_COST_METHOD	NUMBER		Flag to indicate the costing method used for this transaction
AVG_RATES_COST_TYPE_ID	NUMBER		ID for the Average Rates Cost Type
ITEM_DESCRIPTION	VARCHAR2	(240)	description of the item the transaction refers to
COST_GROUP_ID	NUMBER		cost group to which the project of the locator the transaction refers to
TRANSFER_COST_GROUP_ID	NUMBER		cost group to which the project of the transfer locator the transaction refers to
TRANSACTION_SOURCE_ID	NUMBER		Transactions Source Document Number (WO or PO etc)
TO_PROJECT_ID	NUMBER	(15)	project referred by the transfer locator of the transaction
TO_TASK_ID	NUMBER	(15)	task assigned or referred by the transfer locator of the transaction
SOURCE_PROJECT_ID	NUMBER		project referred to by the job or capital project transaction
SOURCE_TASK_ID	NUMBER		task referred to by the job or capital project transaction
TRANSFER_TRANSACTION_ID	NUMBER		transaction id of the transaction the current transaction refers to
ACCT_PERIOD_ID	NUMBER		Accounting period to which the transaction belongs to
EXP_ORG_ID	NUMBER		derived column using the decode statement given below: decode(mtt.type_class,1,mmt.pa_expenditure_org_id,mmt.organization_id)
DISTRIBUTION_ACCOUNT_ID	NUMBER		Account given on a miscellaneous transaction
PM_COST_COLLECTOR_GROUP_ID	NUMBER		group id assigned to the transaction for cost collection
SI_ASSET_YES_NO	NUMBER		Indicates whether SI the transaction refers to is an Asset or Expense
TRANSFER_SI_ASSET_YES_NO	NUMBER		Indicates whether Transfer SI the transaction refers to is an Asset or Expense
PM_COST_COLLECTED	VARCHAR2	(1)	Indicates whether or not cost collection was performed for the current transaction
SUBINVENTORY_CODE	VARCHAR2	(10)	subinventory to which the transaction refers to
TRANSFER_SUBINVENTORY	VARCHAR2	(10)	Subinventory from where the material was transferred to/from
TRANSFER_ORGANIZATION_ID	NUMBER		organization from which the transfer took place
INVENTORY_ASSET_FLAG	VARCHAR2	(1)	Indicates whther the item the transaction refers to is an expense or asset.
FLOW_SCHEDULE	VARCHAR2	(1)	a flag to indicate if the transaction source is a continuous flow schedule

Query Text

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 APPS.CST_PM_MATL_TXN_V;

Dependencies

[top of page]

APPS.CST_PM_MATL_TXN_V references the following:

APPS: MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SECONDARY_INVENTORIES; MTL_SYSTEM_ITEMS; MTL_TRANSACTION_TYPES; PJM_ORG_PARAMETERS; WIP_ACCOUNTING_CLASSES; WIP_DISCRETE_JOBS; WIP_FLOW_SCHEDULES

APPS.CST_PM_MATL_TXN_V is referenced by following:

APPS: CST_PM_PENDING_TXN_V; CST_PRJMFG_COST_COLLECTOR - show dependent code