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_XLA_INV_EVENT_MAP

Object Details

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

This table is used in SLA during processing of material transactions. It serves as a lookup to find which event type and event class should be used based on the transaction action, transaction source type, fob point, organization, transfer pricing flag, and transfer type.
An additional attribute column is used to distinguish between certain event types, such as the implicit cost group transfer in a common issue to wip (CITW attribute) and a regular issue from inventory.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_XLA_INV_EVENT_MAP_U1	NORMAL	UNIQUE	APPS_TS_SEED	EVENT_CLASS_CODE EVENT_TYPE_CODE TRANSACTION_SOURCE_TYPE_ID TRANSACTION_ACTION_ID ORGANIZATION TRANSFER_TYPE FOB_POINT TP ATTRIBUTE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ACTION_ID	NUMBER			TRANSACTION_ACTION_ID from MTL_MATERIAL_TRANSACTIONS
TRANSACTION_SOURCE_TYPE_ID	NUMBER			TRANSACTION_SOURCE_TYPE_ID from MTL_TRANSACTION_ACCOUNTS
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes	SLA Event Class
EVENT_TYPE_CODE	VARCHAR2	(30)	Yes	SLA Event Type
ATTRIBUTE	VARCHAR2	(20)		Used to identify special situations like common issue to WIP, variance transfer etc.
FOB_POINT	NUMBER			FOB_POINT from MTL_MATERIAL_TRANSACTIONS
ORGANIZATION	VARCHAR2	(20)		Tells whether to use the organization or the transfer organization for the corresponding MMT transaction.
TRANSFER_TYPE	VARCHAR2	(20)		SHIP or RCPT
TP	VARCHAR2	(1)		Y or N based on value of CST: Transfer Price Option
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      ATTRIBUTE
,      FOB_POINT
,      ORGANIZATION
,      TRANSFER_TYPE
,      TP
,      ZD_EDITION_NAME
FROM BOM.CST_XLA_INV_EVENT_MAP;

Dependencies

[top of page]

BOM.CST_XLA_INV_EVENT_MAP does not reference any database object

BOM.CST_XLA_INV_EVENT_MAP is referenced by following:

BOM: CST_XLA_INV_EVENT_MAP#