[Home] [Help] [Dependency Information]
Object Name: | CST_MGD_IAL_INVALID_MMT |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_MGD_IAL_INVALID_MMT |
Subobject Name: | |
Status: | VALID |
This table is used to store the material transaction types, which are excluded from reporting in the Inventory Analytical Ledger Report and in the Inventory Trial Balance Report. These reports are the Greek Legal requirements.
This table primarily consists of two important columns: TRANSACTION_SOURCE_TYPE_ID and TRANSACTION_ACTION_ID which in combination makes a unique transaction type of the material transaction. Table will be populated with seed data, which has the exclude list of transaction types according to legal requirements of Greece
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_MGD_IAL_INVALID_MMT_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_ACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Yes | Transaction source type identifier that is associated with the transaction type | |
TRANSACTION_ACTION_ID | NUMBER | Yes | Transaction action identifier that is associated with the transaction type | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM BOM.CST_MGD_IAL_INVALID_MMT;
BOM.CST_MGD_IAL_INVALID_MMT does not reference any database object
BOM.CST_MGD_IAL_INVALID_MMT is referenced by following:
|
|
|