View: AML_LEAD_PROCESSING_STAGES_V

Product:	AMS - Marketing
Description:	This view returns meaning of the evaluation stage
Implementation/DBA Data:	APPS.AML_LEAD_PROCESSING_STAGES_V

View Text

SELECT 'CHANNEL_SELECTION' PROCESS_TYPE
, LOOKUP_CODE
, MEANING
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'SALES_CHANNEL' UNION ALL SELECT 'LEAD_QUALIFICATION' PROCESS_TYPE
, LOOKUP_CODE
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'PV_QUALIFIED_STATUS' UNION ALL SELECT 'LEAD_RATING' PROCESS_TYPE
, TO_CHAR(RANK_ID) LOOKUP_CODE
, MEANING
FROM AS_SALES_LEAD_RANKS_VL

Columns