DBA Data[Home] [Help] [Dependency Information]


TABLE: BOM.CST_XLA_WIP_EVENT_MAP

Object Details
Object Name: CST_XLA_WIP_EVENT_MAP
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_XLA_WIP_EVENT_MAP
Subobject Name:
Status: VALID


This table is used in SLA during processing of wip transactions. It serves as a lookup to find which event type and event class should be used based on the wip transaction type. Also, an attribute column exists to distinguish event types that cannot be uniquely determined from transaction type.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_XLA_WIP_EVENT_MAP_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnEVENT_CLASS_CODE
ColumnEVENT_TYPE_CODE
ColumnTRANSACTION_TYPE_ID
ColumnATTRIBUTE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TYPE_ID NUMBER

TRANSACTION_TYPE from WIP_TRANSACTIONS
ATTRIBUTE VARCHAR2 (20)
Used to identify special situations like IPV transfer to WIP
EVENT_CLASS_CODE VARCHAR2 (30) Yes SLA Event Class
EVENT_TYPE_CODE VARCHAR2 (30) Yes SLA Event Type
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT TRANSACTION_TYPE_ID
,      ATTRIBUTE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      ZD_EDITION_NAME
FROM BOM.CST_XLA_WIP_EVENT_MAP;

Dependencies

[top of page]

BOM.CST_XLA_WIP_EVENT_MAP does not reference any database object

BOM.CST_XLA_WIP_EVENT_MAP is referenced by following:

SchemaBOM
ViewCST_XLA_WIP_EVENT_MAP#