SELECT /* Dummy Comment */ 'CCUST' UMARK,LOOKUP_CODE ID,MEANING VALUE,LANGUAGE LANGUAGE
from FND_LOOKUP_VALUES LV WHERE VIEW_APPLICATION_ID = 222 and SECURITY_GROUP_ID = 0
AND LOOKUP_TYPE = 'CUSTOMER_CATEGORY' AND ENABLED_FLAG = 'Y'
UNION ALL
SELECT 'STATUS' umark,b.status_code id, t.meaning value, t.language
FROM as_statuses_b b, as_statuses_tl t
WHERE b.status_code = t.status_code and b.lead_flag='Y'
UNION ALL
SELECT 'CHANNEL' UMARK,LOOKUP_CODE ID, MEANING VALUE,language language
from FND_LOOKUP_VALUES WHERE VIEW_APPLICATION_ID = 660
and SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)
AND lookup_type = 'SALES_CHANNEL'
UNION ALL
SELECT 'RANK' UMARK,to_char(RANK_ID) ID,MEANING value,language language
from AS_SALES_LEAD_RANKS_TL
UNION ALL
SELECT 'CRES' UMARK,LOOKUP_CODE ID,MEANING VALUE,LANGUAGE LANGUAGE
from FND_LOOKUP_VALUES WHERE VIEW_APPLICATION_ID =279
and SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE, VIEW_APPLICATION_ID)
AND lookup_type = 'CLOSE_REASON'
UNION ALL
select 'STATUS' umark, '-999' id, meaning name, language language
from fnd_lookup_values
where lookup_type = 'BIM_GEN_LOOKUP'
and lookup_code = 'UNA'
UNION ALL
select 'RANK' umark, '-999' id, meaning name, language language
from fnd_lookup_values
where lookup_type = 'BIM_GEN_LOOKUP'
and lookup_code = 'OTH'
UNION ALL
select 'CHANNEL' umark, '-999' id, meaning name, language language
from fnd_lookup_values
where lookup_type = 'BIM_GEN_LOOKUP'
and lookup_code = 'UNA'
UNION ALL
select 'CCUST' umark, '-999' id, meaning name, language language
from fnd_lookup_values
where lookup_type = 'BIM_GEN_LOOKUP'
and lookup_code = 'UNA'
UNION ALL
select 'CRES' umark, '-999' id, meaning name, language language
from fnd_lookup_values
where lookup_type = 'BIM_GEN_LOOKUP'
and lookup_code = 'UNA'
[Home] [Help]