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

TABLE: BOM.CST_MGD_INFL_ADJ_KARDEX_DATA

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


CST_MGD_INFL_ADJ_KARDEX_DATA is a temporary table containing Kardex data for reporting. It is
populated according to user parameters defined when the Kardex report is run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization Identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
TXN_DATE DATE

Transfer Date
TXN_TYPE VARCHAR2 (30)
Transfer Type
TXN_INI_QTY NUMBER
Yes Initial Transfer Quantity
TXN_INI_UNIT_COST NUMBER
Yes Initial Transfer Unit Cost
TXN_INI_H_TOTAL_COST NUMBER
Yes Initial Transfer Historical Total Cost
TXN_INI_ADJ_TOTAL_COST NUMBER
Yes Initial Transfer Adjustment Total Cost
TXN_QTY NUMBER

Transfer Quantities
TXN_UNIT_COST NUMBER

Transfer Unit Cost
TXN_H_TOTAL_COST NUMBER

Transfer Historical Total Cost
TXN_ADJ_TOTAL_COST NUMBER

Transfer Adjustment Total Cost
TXN_FNL_QTY NUMBER
Yes Transfer Final Quantity
TXN_FNL_UNIT_COST NUMBER
Yes Transfer Final Unit Cost
TXN_FNL_H_TOTAL_COST NUMBER
Yes Transfer Final Historical Total Cost
TXN_FNL_ADJ_TOTAL_COST NUMBER
Yes Transfer Final Adjustment Total Cost
CREATION_DATE DATE

TRANSACTION_ID NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TXN_DATE
,      TXN_TYPE
,      TXN_INI_QTY
,      TXN_INI_UNIT_COST
,      TXN_INI_H_TOTAL_COST
,      TXN_INI_ADJ_TOTAL_COST
,      TXN_QTY
,      TXN_UNIT_COST
,      TXN_H_TOTAL_COST
,      TXN_ADJ_TOTAL_COST
,      TXN_FNL_QTY
,      TXN_FNL_UNIT_COST
,      TXN_FNL_H_TOTAL_COST
,      TXN_FNL_ADJ_TOTAL_COST
,      CREATION_DATE
,      TRANSACTION_ID
FROM BOM.CST_MGD_INFL_ADJ_KARDEX_DATA;

Dependencies

[top of page]

BOM.CST_MGD_INFL_ADJ_KARDEX_DATA does not reference any database object

BOM.CST_MGD_INFL_ADJ_KARDEX_DATA is referenced by following:

SchemaAPPS
SynonymCST_MGD_INFL_ADJ_KARDEX_DATA