DBA Data[Home] [Help]

VIEW: APPS.AST_SALESLEAD_UWQ_REF_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'