VIEW: HR.PAY_US_RPT_TOTALS#

Source

View Text - Preformatted

select SESSION_ID SESSION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, TAX_UNIT_ID TAX_UNIT_ID, GRE_NAME GRE_NAME, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_NAME ORGANIZATION_NAME, LOCATION_ID LOCATION_ID, LOCATION_NAME LOCATION_NAME, STATE_CODE STATE_CODE, STATE_ABBREV STATE_ABBREV, STATE_NAME STATE_NAME, VALUE1 VALUE1, VALUE2 VALUE2, VALUE3 VALUE3, VALUE4 VALUE4, VALUE5 VALUE5, VALUE6 VALUE6, VALUE7 VALUE7, VALUE8 VALUE8, VALUE9 VALUE9, VALUE10 VALUE10, VALUE11 VALUE11, VALUE12 VALUE12, VALUE13 VALUE13, VALUE14 VALUE14, VALUE15 VALUE15, VALUE16 VALUE16, VALUE17 VALUE17, VALUE18 VALUE18, VALUE19 VALUE19, VALUE20 VALUE20, VALUE21 VALUE21, VALUE22 VALUE22, VALUE23 VALUE23, VALUE24 VALUE24, VALUE25 VALUE25, VALUE26 VALUE26, VALUE27 VALUE27, VALUE28 VALUE28, VALUE29 VALUE29, VALUE30 VALUE30, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ATTRIBUTE31 ATTRIBUTE31, ATTRIBUTE32 ATTRIBUTE32, ATTRIBUTE33 ATTRIBUTE33, ATTRIBUTE34 ATTRIBUTE34, ATTRIBUTE35 ATTRIBUTE35, ATTRIBUTE36 ATTRIBUTE36, ATTRIBUTE37 ATTRIBUTE37, ATTRIBUTE38 ATTRIBUTE38, ATTRIBUTE39 ATTRIBUTE39, ATTRIBUTE40 ATTRIBUTE40, ATTRIBUTE41 ATTRIBUTE41, ATTRIBUTE42 ATTRIBUTE42, ATTRIBUTE43 ATTRIBUTE43, ATTRIBUTE44 ATTRIBUTE44, ATTRIBUTE45 ATTRIBUTE45 from "HR"."PAY_US_RPT_TOTALS"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TAX_UNIT_ID TAX_UNIT_ID
, GRE_NAME GRE_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, LOCATION_ID LOCATION_ID
, LOCATION_NAME LOCATION_NAME
, STATE_CODE STATE_CODE
, STATE_ABBREV STATE_ABBREV
, STATE_NAME STATE_NAME
, VALUE1 VALUE1
, VALUE2 VALUE2
, VALUE3 VALUE3
, VALUE4 VALUE4
, VALUE5 VALUE5
, VALUE6 VALUE6
, VALUE7 VALUE7
, VALUE8 VALUE8
, VALUE9 VALUE9
, VALUE10 VALUE10
, VALUE11 VALUE11
, VALUE12 VALUE12
, VALUE13 VALUE13
, VALUE14 VALUE14
, VALUE15 VALUE15
, VALUE16 VALUE16
, VALUE17 VALUE17
, VALUE18 VALUE18
, VALUE19 VALUE19
, VALUE20 VALUE20
, VALUE21 VALUE21
, VALUE22 VALUE22
, VALUE23 VALUE23
, VALUE24 VALUE24
, VALUE25 VALUE25
, VALUE26 VALUE26
, VALUE27 VALUE27
, VALUE28 VALUE28
, VALUE29 VALUE29
, VALUE30 VALUE30
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ATTRIBUTE31 ATTRIBUTE31
, ATTRIBUTE32 ATTRIBUTE32
, ATTRIBUTE33 ATTRIBUTE33
, ATTRIBUTE34 ATTRIBUTE34
, ATTRIBUTE35 ATTRIBUTE35
, ATTRIBUTE36 ATTRIBUTE36
, ATTRIBUTE37 ATTRIBUTE37
, ATTRIBUTE38 ATTRIBUTE38
, ATTRIBUTE39 ATTRIBUTE39
, ATTRIBUTE40 ATTRIBUTE40
, ATTRIBUTE41 ATTRIBUTE41
, ATTRIBUTE42 ATTRIBUTE42
, ATTRIBUTE43 ATTRIBUTE43
, ATTRIBUTE44 ATTRIBUTE44
, ATTRIBUTE45 ATTRIBUTE45
FROM "HR"."PAY_US_RPT_TOTALS"