[Home] [Help]
View: AST_SALESLEAD_UWQ_REF_V
View Text
SELECT LEAD.ASSIGN_TO_SALESFORCE_ID RESOURCE_ID
, LEAD.SALES_LEAD_ID SALES_LEAD_ID
, LEAD.CREATION_DATE CREATION_DATE
, LEAD.STATUS_CODE
FROM AS_SALES_LEADS LEAD
WHERE LEAD.STATUS_OPEN_FLAG = 'Y'
Columns
Name |
RESOURCE_ID |
SALES_LEAD_ID |
CREATION_DATE |
STATUS_CODE |