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: TableBOM.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: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
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)
SLA Event Class
EVENT_TYPE_CODE VARCHAR2 (30)
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
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
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:

SchemaAPPS
SynonymCST_XLA_INV_EVENT_MAP