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_DIAG_ERRORED_TXNS

Object Details

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

Temp table for Costing diagnostics

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization identifier
BOTTLE_NECK_TXN_ID	NUMBER		Transaction id holding the costing of other transactions
TRANSACTION_DATE	DATE		Transaction date
TRANSACTION_ORGANIZATION_ID	NUMBER		Organization id in which transaction exists
TRANSFER_ORGANIZATION_ID	NUMBER		Transfer opposing organization id
TRANSFER_TRANSACTION_ID	NUMBER		Transaction id of the opposing transfer transaction
TRANSACTION_ACTION_ID	NUMBER		Transaction action identifier
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Transaction source type identifier
TRANSACTION_COST	NUMBER		Transaction source type identifier
SHIPMENT_COSTED	VARCHAR2	(1)	Indicates if the shipment transaction has been processed by the cost worker
MOVE_TRANSACTION_ID	NUMBER		Move transaction cross reference
COMPLETION_TRANSACTION_ID	NUMBER		Completion transaction cross reference
COSTED_FLAG	VARCHAR2	(1)	Costed flag to mark if the transactions are costed or not
WAITING_ORGANIZATION_ID	NUMBER		Organization id containing transactions to be costed
LOGICAL_TXN_CREATED	NUMBER	(1)	Flag to mark logical transactions are created or not

Query Text

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


SELECT ORGANIZATION_ID
,      BOTTLE_NECK_TXN_ID
,      TRANSACTION_DATE
,      TRANSACTION_ORGANIZATION_ID
,      TRANSFER_ORGANIZATION_ID
,      TRANSFER_TRANSACTION_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_COST
,      SHIPMENT_COSTED
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      COSTED_FLAG
,      WAITING_ORGANIZATION_ID
,      LOGICAL_TXN_CREATED
FROM BOM.CST_DIAG_ERRORED_TXNS;

Dependencies

[top of page]

BOM.CST_DIAG_ERRORED_TXNS does not reference any database object

BOM.CST_DIAG_ERRORED_TXNS is referenced by following:

APPS: CST_DIAG_ERRORED_TXNS