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: JA.JAI_MTL_TXN_CST_HDR_T

Object Details

Object Name:	JAI_MTL_TXN_CST_HDR_T
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_MTL_TXN_CST_HDR_T
Subobject Name:
Status:	VALID

This is a temporary table which is used to replicate data as in MTL_TRANSACTIONS_INTERFACE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_HEADER_ID	NUMBER		Yes	Transaction Header identifier
ORGANIZATION_ID	NUMBER			Organization identifier
REVISION	VARCHAR2	(3)		Revision
TRANSACTION_QUANTITY	NUMBER			Transaction Quantity
TRANSACTION_DATE	DATE			Transaction Date
TRANSACTION_SOURCE_NAME	VARCHAR2	(30)		Transaction Source Name. Value is 'Avg Cost Update Conversion' for Oracle Financials for India.
TRANSACTION_TYPE_ID	NUMBER			Transaction Type Identifier
TRANSACTION_SOURCE_TYPE_ID	NUMBER			Transaction Source Type Identifier
RCV_TRANSACTION_ID	NUMBER			Refers to the jai_rcv_journal_entries.transaction_id
TRANSACTION_REFERENCE	VARCHAR2	(240)		Refers to the jai_rcv_journal_entries.transaction_id
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
COST_GROUP_ID	NUMBER			Cost Group Identifier
MATERIAL_ACCOUNT	NUMBER			Material Account Identifier
MATERIAL_OVERHEAD_ACCOUNT	NUMBER			Material Overhead Account Identifier
RESOURCE_ACCOUNT	NUMBER			Resource Account Identifier
TRANSACTION_ID	NUMBER			Transaction identifier
SOURCE_CODE	VARCHAR2	(30)		Source Code
SOURCE_LINE_ID	NUMBER			Source Line identifier
SOURCE_HEADER_ID	NUMBER			Source Header identifier
PROCESS_FLAG	NUMBER	(1)		Flag to indicate if record has been processed
TRANSACTION_MODE	NUMBER			Transaction Mode
OVERHEAD_ACCOUNT	NUMBER			Overhead Account Identifier
OUTSIDE_PROCESSING_ACCOUNT	NUMBER			Outside Processing Account Identifier
LOCK_FLAG	NUMBER	(1)		Lock Flag
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
INVENTORY_ITEM_ID	NUMBER			Item identifier
TRANSACTION_INTERFACE_ID	NUMBER			Transaction Interface identifier
TRANSACTION_UOM	VARCHAR2	(3)		Transaction Unit Of Measure

Query Text

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


SELECT TRANSACTION_HEADER_ID
,      ORGANIZATION_ID
,      REVISION
,      TRANSACTION_QUANTITY
,      TRANSACTION_DATE
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      RCV_TRANSACTION_ID
,      TRANSACTION_REFERENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      COST_GROUP_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      TRANSACTION_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      SOURCE_HEADER_ID
,      PROCESS_FLAG
,      TRANSACTION_MODE
,      OVERHEAD_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      LOCK_FLAG
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      TRANSACTION_INTERFACE_ID
,      TRANSACTION_UOM
FROM JA.JAI_MTL_TXN_CST_HDR_T;

Dependencies

[top of page]

JA.JAI_MTL_TXN_CST_HDR_T does not reference any database object

JA.JAI_MTL_TXN_CST_HDR_T is referenced by following:

APPS: JAI_MTL_TXN_CST_HDR_T