[Home] [Help] [Dependency Information]
Object Name: | T_SRC_ITEM_TMPL |
---|---|
Object Type: | TABLE |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EQ_UNIT | NUMBER | (20) | ||
T_EP_I_ATT_1 | VARCHAR2 | (100) | ||
T_EP_I_ATT_10 | VARCHAR2 | (100) | ||
T_EP_I_ATT_2 | VARCHAR2 | (100) | ||
T_EP_I_ATT_3 | VARCHAR2 | (100) | ||
T_EP_I_ATT_4 | VARCHAR2 | (100) | ||
T_EP_I_ATT_5 | VARCHAR2 | (100) | ||
T_EP_I_ATT_6 | VARCHAR2 | (100) | ||
T_EP_I_ATT_7 | VARCHAR2 | (100) | ||
T_EP_I_ATT_8 | VARCHAR2 | (100) | ||
T_EP_I_ATT_9 | VARCHAR2 | (100) | ||
T_EP_P1 | VARCHAR2 | (100) | ||
T_EP_P2 | VARCHAR2 | (100) | ||
T_EP_P2A | VARCHAR2 | (100) | ||
T_EP_P2A1 | VARCHAR2 | (100) | ||
T_EP_P2A2 | VARCHAR2 | (100) | ||
T_EP_P2B | VARCHAR2 | (100) | ||
T_EP_P3 | VARCHAR2 | (100) | ||
T_EP_P4 | VARCHAR2 | (100) | ||
DM_ITEM_CODE | VARCHAR2 | (240) | ||
DM_ITEM_DESC | VARCHAR2 | (240) | ||
E1_PLANNING_UOM | VARCHAR2 | (100) | ||
E1_SHIPPING_UOM | VARCHAR2 | (100) | ||
E1_SHIPPING_UOM_MULTIPLE | NUMBER | (20) | ||
E1_WEIGHT_UOM | VARCHAR2 | (100) | ||
E1_WEIGHT_UOM_MULTIPLE | NUMBER | (20) | ||
E1_VOLUME_UOM | VARCHAR2 | (100) | ||
E1_VOLUME_UOM_MULTIPLE | NUMBER | (20) | ||
E1_PRIMARY_UOM | VARCHAR2 | (100) | ||
E1_PRIMARY_PLANNING_FACTOR | NUMBER | (20) | ||
E1_ITEM_CATEGORY_1 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_2 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_3 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_4 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_5 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_6 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_7 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_8 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_9 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_10 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_11 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_12 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_13 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_14 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_15 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_16 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_17 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_18 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_19 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_20 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_21 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_22 | VARCHAR2 | (100) | ||
E1_ITEM_CATEGORY_23 | VARCHAR2 | (100) | ||
EBS_PRODUCT_CATEGORY_CODE | VARCHAR2 | (240) | ||
EBS_PRODUCT_CATEGORY_DESC | VARCHAR2 | (240) | ||
EBS_PRODUCT_FAMILY_CODE | VARCHAR2 | (240) | ||
EBS_PRODUCT_FAMILY_DESC | VARCHAR2 | (240) | ||
EBS_DEMAND_CLASS_CODE | VARCHAR2 | (240) | ||
EBS_DEMAND_CLASS_DESC | VARCHAR2 | (240) | ||
EBS_ITEM_DEST_KEY | NUMBER | (10) | ||
EBS_DEMAND_CLASS_DEST_KEY | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT EQ_UNIT
, T_EP_I_ATT_1
, T_EP_I_ATT_10
, T_EP_I_ATT_2
, T_EP_I_ATT_3
, T_EP_I_ATT_4
, T_EP_I_ATT_5
, T_EP_I_ATT_6
, T_EP_I_ATT_7
, T_EP_I_ATT_8
, T_EP_I_ATT_9
, T_EP_P1
, T_EP_P2
, T_EP_P2A
, T_EP_P2A1
, T_EP_P2A2
, T_EP_P2B
, T_EP_P3
, T_EP_P4
, DM_ITEM_CODE
, DM_ITEM_DESC
, E1_PLANNING_UOM
, E1_SHIPPING_UOM
, E1_SHIPPING_UOM_MULTIPLE
, E1_WEIGHT_UOM
, E1_WEIGHT_UOM_MULTIPLE
, E1_VOLUME_UOM
, E1_VOLUME_UOM_MULTIPLE
, E1_PRIMARY_UOM
, E1_PRIMARY_PLANNING_FACTOR
, E1_ITEM_CATEGORY_1
, E1_ITEM_CATEGORY_2
, E1_ITEM_CATEGORY_3
, E1_ITEM_CATEGORY_4
, E1_ITEM_CATEGORY_5
, E1_ITEM_CATEGORY_6
, E1_ITEM_CATEGORY_7
, E1_ITEM_CATEGORY_8
, E1_ITEM_CATEGORY_9
, E1_ITEM_CATEGORY_10
, E1_ITEM_CATEGORY_11
, E1_ITEM_CATEGORY_12
, E1_ITEM_CATEGORY_13
, E1_ITEM_CATEGORY_14
, E1_ITEM_CATEGORY_15
, E1_ITEM_CATEGORY_16
, E1_ITEM_CATEGORY_17
, E1_ITEM_CATEGORY_18
, E1_ITEM_CATEGORY_19
, E1_ITEM_CATEGORY_20
, E1_ITEM_CATEGORY_21
, E1_ITEM_CATEGORY_22
, E1_ITEM_CATEGORY_23
, EBS_PRODUCT_CATEGORY_CODE
, EBS_PRODUCT_CATEGORY_DESC
, EBS_PRODUCT_FAMILY_CODE
, EBS_PRODUCT_FAMILY_DESC
, EBS_DEMAND_CLASS_CODE
, EBS_DEMAND_CLASS_DESC
, EBS_ITEM_DEST_KEY
, EBS_DEMAND_CLASS_DEST_KEY
FROM MSD.T_SRC_ITEM_TMPL;
MSD.T_SRC_ITEM_TMPL does not reference any database object
MSD.T_SRC_ITEM_TMPL is referenced by following:
|
|
|