VIEW: BIM.BIM_I_SOURCE_CODES#

Source

View Text - Preformatted

select CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJ_LAST_UPDATE_DATE OBJ_LAST_UPDATE_DATE, SOURCE_CODE_ID SOURCE_CODE_ID, SOURCE_CODE SOURCE_CODE, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_STATUS OBJECT_STATUS, OBJECT_PURPOSE OBJECT_PURPOSE, OBJECT_COUNTRY OBJECT_COUNTRY, OBJECT_REGION OBJECT_REGION, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, OWNER_USER_ID OWNER_USER_ID, START_DATE START_DATE, END_DATE END_DATE, CATEGORY_ID CATEGORY_ID, CHILD_OBJECT_ID CHILD_OBJECT_ID, CHILD_OBJECT_TYPE CHILD_OBJECT_TYPE, CHILD_OBJECT_STATUS CHILD_OBJECT_STATUS, CHILD_OBJECT_PURPOSE CHILD_OBJECT_PURPOSE, CHILD_OBJECT_COUNTRY CHILD_OBJECT_COUNTRY, CHILD_OBJECT_REGION CHILD_OBJECT_REGION, CHILD_OBJECT_USAGE CHILD_OBJECT_USAGE, ACTIVITY_ID ACTIVITY_ID, ACTIVITY_TYPE ACTIVITY_TYPE, ADJ_START_DATE ADJ_START_DATE, ADJ_END_DATE ADJ_END_DATE, METRIC1 METRIC1, METRIC2 METRIC2, METRIC3 METRIC3, METRIC4 METRIC4, METRIC5 METRIC5, METRIC6 METRIC6, METRIC7 METRIC7, METRIC8 METRIC8, METRIC9 METRIC9, METRIC10 METRIC10, METRIC11 METRIC11, METRIC12 METRIC12, METRIC13 METRIC13, METRIC14 METRIC14, METRIC15 METRIC15, SECURITY_GROUP_ID SECURITY_GROUP_ID, PARENT_SOURCE_CODE_ID PARENT_SOURCE_CODE_ID, ROLLUP_TYPE ROLLUP_TYPE from "BIM"."BIM_I_SOURCE_CODES"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJ_LAST_UPDATE_DATE OBJ_LAST_UPDATE_DATE
, SOURCE_CODE_ID SOURCE_CODE_ID
, SOURCE_CODE SOURCE_CODE
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_STATUS OBJECT_STATUS
, OBJECT_PURPOSE OBJECT_PURPOSE
, OBJECT_COUNTRY OBJECT_COUNTRY
, OBJECT_REGION OBJECT_REGION
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, OWNER_USER_ID OWNER_USER_ID
, START_DATE START_DATE
, END_DATE END_DATE
, CATEGORY_ID CATEGORY_ID
, CHILD_OBJECT_ID CHILD_OBJECT_ID
, CHILD_OBJECT_TYPE CHILD_OBJECT_TYPE
, CHILD_OBJECT_STATUS CHILD_OBJECT_STATUS
, CHILD_OBJECT_PURPOSE CHILD_OBJECT_PURPOSE
, CHILD_OBJECT_COUNTRY CHILD_OBJECT_COUNTRY
, CHILD_OBJECT_REGION CHILD_OBJECT_REGION
, CHILD_OBJECT_USAGE CHILD_OBJECT_USAGE
, ACTIVITY_ID ACTIVITY_ID
, ACTIVITY_TYPE ACTIVITY_TYPE
, ADJ_START_DATE ADJ_START_DATE
, ADJ_END_DATE ADJ_END_DATE
, METRIC1 METRIC1
, METRIC2 METRIC2
, METRIC3 METRIC3
, METRIC4 METRIC4
, METRIC5 METRIC5
, METRIC6 METRIC6
, METRIC7 METRIC7
, METRIC8 METRIC8
, METRIC9 METRIC9
, METRIC10 METRIC10
, METRIC11 METRIC11
, METRIC12 METRIC12
, METRIC13 METRIC13
, METRIC14 METRIC14
, METRIC15 METRIC15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PARENT_SOURCE_CODE_ID PARENT_SOURCE_CODE_ID
, ROLLUP_TYPE ROLLUP_TYPE
FROM "BIM"."BIM_I_SOURCE_CODES"