VIEW: DDR.DDR_S_SYND_CNSMPTN_DATA#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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