eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: MSD.T_SRC_ITEM_TMPL#

Object Details

Object Name:	T_SRC_ITEM_TMPL#
Object Type:	VIEW
Owner:	MSD
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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)

Query Text

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#;

Dependencies

[top of page]

MSD.T_SRC_ITEM_TMPL# references the following:

MSD: T_SRC_ITEM_TMPL

MSD.T_SRC_ITEM_TMPL# is referenced by following:

APPS: T_SRC_ITEM_TMPL