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: DDR.DDR_E_SYND_CNSMPTN_DATA#

Object Details

Object Name:	DDR_E_SYND_CNSMPTN_DATA#
Object Type:	VIEW
Owner:	DDR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REC_ID	NUMBER		Yes
LOAD_ID	NUMBER		Yes
ERR_REASON	VARCHAR2	(500)	Yes
SRC_CD	VARCHAR2	(30)
PROD_KEY	VARCHAR2	(30)
MFG_ITM_HCHY_LVL	VARCHAR2	(30)
MFG_ITM_HCHY_CD	VARCHAR2	(30)
MFG_ITM_HCHY_ID	NUMBER
GEO_KEY	VARCHAR2	(30)
MKT_AREA_CD	VARCHAR2	(30)
MKT_AREA_TYP	VARCHAR2	(30)
MKT_AREA_ID	NUMBER
RTL_ORG_HCHY_LVL	VARCHAR2	(30)
RTL_ORG_HCHY_CD	VARCHAR2	(30)
RTL_ORG_CD	VARCHAR2	(30)
RTL_ORG_HCHY_ID	NUMBER
GEO_RGN_CD	VARCHAR2	(30)
GEO_RGN_ID	NUMBER
GEO_SUB_RGN_CD	VARCHAR2	(30)
GEO_SUB_RGN_ID	NUMBER
CHNL_TYP_CD	VARCHAR2	(30)
PERIOD_END_DATE	DATE
TIME_HCHY_LVL	VARCHAR2	(30)
PERIOD_ID	NUMBER
SRC_SYS_IDNT	VARCHAR2	(40)	Yes
SRC_SYS_DT	DATE		Yes
SRC_IDNT_FLAG	VARCHAR2	(1)
ACTION_FLAG	VARCHAR2	(1)
MEASURE_SET	VARCHAR2	(30)
MEASURE1	NUMBER
MEASURE2	NUMBER
MEASURE3	NUMBER
MEASURE4	NUMBER
MEASURE5	NUMBER
MEASURE6	NUMBER
MEASURE7	NUMBER
MEASURE8	NUMBER
MEASURE9	NUMBER
MEASURE10	NUMBER
MEASURE11	NUMBER
MEASURE12	NUMBER
MEASURE13	NUMBER
MEASURE14	NUMBER
MEASURE15	NUMBER
MEASURE16	NUMBER
MEASURE17	NUMBER
MEASURE18	NUMBER
MEASURE19	NUMBER
MEASURE20	NUMBER
MEASURE21	NUMBER
MEASURE22	NUMBER
MEASURE23	NUMBER
MEASURE24	NUMBER
MEASURE25	NUMBER
MEASURE26	NUMBER
MEASURE27	NUMBER
MEASURE28	NUMBER
MEASURE29	NUMBER
MEASURE30	NUMBER
MEASURE31	NUMBER
MEASURE32	NUMBER
MEASURE33	NUMBER
MEASURE34	NUMBER
MEASURE35	NUMBER
MEASURE36	NUMBER
MEASURE37	NUMBER
MEASURE38	NUMBER
MEASURE39	NUMBER
MEASURE40	NUMBER
MEASURE41	NUMBER
MEASURE42	NUMBER
MEASURE43	NUMBER
MEASURE44	NUMBER
MEASURE45	NUMBER
MEASURE46	NUMBER
MEASURE47	NUMBER
MEASURE48	NUMBER
MEASURE49	NUMBER
MEASURE50	NUMBER
MEASURE51	NUMBER
MEASURE52	NUMBER
MEASURE53	NUMBER
MEASURE54	NUMBER
MEASURE55	NUMBER
MEASURE56	NUMBER
MEASURE57	NUMBER
MEASURE58	NUMBER
MEASURE59	NUMBER
MEASURE60	NUMBER
MEASURE61	NUMBER
MEASURE62	NUMBER
MEASURE63	NUMBER
MEASURE64	NUMBER
MEASURE65	NUMBER
MEASURE66	NUMBER
MEASURE67	NUMBER
MEASURE68	NUMBER
MEASURE69	NUMBER
MEASURE70	NUMBER
MEASURE71	NUMBER
MEASURE72	NUMBER
MEASURE73	NUMBER
MEASURE74	NUMBER
MEASURE75	NUMBER
MEASURE76	NUMBER
MEASURE77	NUMBER
MEASURE78	NUMBER
MEASURE79	NUMBER
MEASURE80	NUMBER
MEASURE81	NUMBER
MEASURE82	NUMBER
MEASURE83	NUMBER
MEASURE84	NUMBER
MEASURE85	NUMBER
MEASURE86	NUMBER
MEASURE87	NUMBER
MEASURE88	NUMBER
MEASURE89	NUMBER
MEASURE90	NUMBER
MEASURE91	NUMBER
MEASURE92	NUMBER
MEASURE93	NUMBER
MEASURE94	NUMBER
MEASURE95	NUMBER
MEASURE96	NUMBER
MEASURE97	NUMBER
MEASURE98	NUMBER
MEASURE99	NUMBER
MEASURE100	NUMBER
ACCT_CD	VARCHAR2	(30)
AO_HCHY_CD	VARCHAR2	(30)

Query Text

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


SELECT REC_ID
,      LOAD_ID
,      ERR_REASON
,      SRC_CD
,      PROD_KEY
,      MFG_ITM_HCHY_LVL
,      MFG_ITM_HCHY_CD
,      MFG_ITM_HCHY_ID
,      GEO_KEY
,      MKT_AREA_CD
,      MKT_AREA_TYP
,      MKT_AREA_ID
,      RTL_ORG_HCHY_LVL
,      RTL_ORG_HCHY_CD
,      RTL_ORG_CD
,      RTL_ORG_HCHY_ID
,      GEO_RGN_CD
,      GEO_RGN_ID
,      GEO_SUB_RGN_CD
,      GEO_SUB_RGN_ID
,      CHNL_TYP_CD
,      PERIOD_END_DATE
,      TIME_HCHY_LVL
,      PERIOD_ID
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      SRC_IDNT_FLAG
,      ACTION_FLAG
,      MEASURE_SET
,      MEASURE1
,      MEASURE2
,      MEASURE3
,      MEASURE4
,      MEASURE5
,      MEASURE6
,      MEASURE7
,      MEASURE8
,      MEASURE9
,      MEASURE10
,      MEASURE11
,      MEASURE12
,      MEASURE13
,      MEASURE14
,      MEASURE15
,      MEASURE16
,      MEASURE17
,      MEASURE18
,      MEASURE19
,      MEASURE20
,      MEASURE21
,      MEASURE22
,      MEASURE23
,      MEASURE24
,      MEASURE25
,      MEASURE26
,      MEASURE27
,      MEASURE28
,      MEASURE29
,      MEASURE30
,      MEASURE31
,      MEASURE32
,      MEASURE33
,      MEASURE34
,      MEASURE35
,      MEASURE36
,      MEASURE37
,      MEASURE38
,      MEASURE39
,      MEASURE40
,      MEASURE41
,      MEASURE42
,      MEASURE43
,      MEASURE44
,      MEASURE45
,      MEASURE46
,      MEASURE47
,      MEASURE48
,      MEASURE49
,      MEASURE50
,      MEASURE51
,      MEASURE52
,      MEASURE53
,      MEASURE54
,      MEASURE55
,      MEASURE56
,      MEASURE57
,      MEASURE58
,      MEASURE59
,      MEASURE60
,      MEASURE61
,      MEASURE62
,      MEASURE63
,      MEASURE64
,      MEASURE65
,      MEASURE66
,      MEASURE67
,      MEASURE68
,      MEASURE69
,      MEASURE70
,      MEASURE71
,      MEASURE72
,      MEASURE73
,      MEASURE74
,      MEASURE75
,      MEASURE76
,      MEASURE77
,      MEASURE78
,      MEASURE79
,      MEASURE80
,      MEASURE81
,      MEASURE82
,      MEASURE83
,      MEASURE84
,      MEASURE85
,      MEASURE86
,      MEASURE87
,      MEASURE88
,      MEASURE89
,      MEASURE90
,      MEASURE91
,      MEASURE92
,      MEASURE93
,      MEASURE94
,      MEASURE95
,      MEASURE96
,      MEASURE97
,      MEASURE98
,      MEASURE99
,      MEASURE100
,      ACCT_CD
,      AO_HCHY_CD
FROM DDR.DDR_E_SYND_CNSMPTN_DATA#;

Dependencies

[top of page]

DDR.DDR_E_SYND_CNSMPTN_DATA# references the following:

DDR: DDR_E_SYND_CNSMPTN_DATA

DDR.DDR_E_SYND_CNSMPTN_DATA# is referenced by following:

APPS: DDR_E_SYND_CNSMPTN_DATA