DBA Data[Home] [Help]

VIEW: BIM.BIM_R_LEAD_SO_FACTS_TEMP#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, LEAD_STATUS LEAD_STATUS, OPEN_FLAG OPEN_FLAG, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, REGION REGION, COUNTRY COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, MONTH MONTH, QTR QTR, YEAR YEAR, A A, B B, C C, D D, E E, F F, G G, H H, I I, J J, OTHERS OTHERS from "BIM"."BIM_R_LEAD_SO_FACTS_TEMP"
View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, LEAD_STATUS LEAD_STATUS
, OPEN_FLAG OPEN_FLAG
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, REGION REGION
, COUNTRY COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, MONTH MONTH
, QTR QTR
, YEAR YEAR
, A A
, B B
, C C
, D D
, E E
, F F
, G G
, H H
, I I
, J J
, OTHERS OTHERS
FROM "BIM"."BIM_R_LEAD_SO_FACTS_TEMP"