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

TABLE: GMD.FM_FORM_EFF_BAK

Object Details
Object Name: FM_FORM_EFF_BAK
Object Type: TABLE
Owner: GMD
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FM_FORM_EFFI1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnFORMULA_ID
ColumnORGN_CODE
ColumnFORMULA_USE
ColumnEND_DATE
ColumnDELETE_MARK
FM_FORM_EFFI2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnORGN_CODE
ColumnITEM_ID
ColumnFORMULA_USE
ColumnEND_DATE
ColumnFMEFF_ID
FM_FORM_EFFI4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnROUTING_ID
Columns
Name Datatype Length Mandatory Comments
FMEFF_ID NUMBER (10) Yes
ORGN_CODE VARCHAR2 (4)
ITEM_ID NUMBER (10) Yes
FORMULA_USE NUMBER (5) Yes
END_DATE DATE
Yes
START_DATE DATE
Yes
INV_MIN_QTY NUMBER
Yes
INV_MAX_QTY NUMBER
Yes
MIN_QTY NUMBER
Yes
MAX_QTY NUMBER
Yes
STD_QTY NUMBER
Yes
ITEM_UM VARCHAR2 (4) Yes
PREFERENCE NUMBER (5) Yes
ROUTING_ID NUMBER (10)
FORMULA_ID NUMBER (10) Yes
CUST_ID NUMBER (10)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
DELETE_MARK NUMBER (5) Yes
TEXT_CODE NUMBER (10)
TRANS_CNT NUMBER (10)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT FMEFF_ID
,      ORGN_CODE
,      ITEM_ID
,      FORMULA_USE
,      END_DATE
,      START_DATE
,      INV_MIN_QTY
,      INV_MAX_QTY
,      MIN_QTY
,      MAX_QTY
,      STD_QTY
,      ITEM_UM
,      PREFERENCE
,      ROUTING_ID
,      FORMULA_ID
,      CUST_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      LAST_UPDATE_LOGIN
FROM GMD.FM_FORM_EFF_BAK;

Dependencies

[top of page]

GMD.FM_FORM_EFF_BAK does not reference any database object

GMD.FM_FORM_EFF_BAK is referenced by following:

SchemaGMD
ViewFM_FORM_EFF_BAK#