[Home] [Help]
View: EDW_BIM_LSTA_LEADSTATUS_LCV
Product: | BIM - Marketing Intelligence |
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 |