[Home] [Help]
View: EDW_BIM_LSTA_LEADSTATUS_LCV
| Product: | BIM - Marketing Intelligence(Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AST.STATUS_CODE || '-' || INST.INSTANCE_CODE LEAD_STATUS_PK
, 'ALL' ALL_FK
, AST.MEANING LEAD_STATUS_DP
, AST.MEANING NAME
, AST.STATUS_CODE STATUS_CODE
, AST.MEANING MEANING
, AST.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AST.CREATION_DATE CREATION_DATE
FROM AS_STATUSES_VL AST
, EDW_LOCAL_INSTANCE INST
WHERE AST.LEAD_FLAG = 'Y'
AND AST.ENABLED_FLAG = 'Y' WITH READ ONLY
Columns
| Name |
| LEAD_STATUS_PK |
| ALL_FK |
| LEAD_STATUS_DP |
| NAME |
| STATUS_CODE |
| MEANING |
| DESCRIPTION |
| INSTANCE |
| LAST_UPDATE_DATE |
| CREATION_DATE |