Skip to content

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

TABLE: DDR.DDR_E_SYND_CNSMPTN_DATA

Object Details
Object Name: DDR_E_SYND_CNSMPTN_DATA
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
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)
Account Code
AO_HCHY_CD VARCHAR2 (30)
Hierarchy Code
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 does not reference any database object

DDR.DDR_E_SYND_CNSMPTN_DATA is referenced by following:

SchemaDDR
ViewDDR_E_SYND_CNSMPTN_DATA#