VIEW: APPS.CSF_M_LOOKUPS_V

Source

View Text - Preformatted

SELECT acc.access_id, val.lookup_type, val.lookup_code, val.meaning, val.description, val.view_application_id, val.security_group_id, val.language, val.ENABLED_FLAG, val.START_DATE_ACTIVE, val.END_DATE_ACTIVE, val.TERRITORY_CODE, val.TAG FROM fnd_lookup_values val, csm_lookups_acc acc WHERE acc.lookup_type = val.lookup_type AND acc.language = val.language AND acc.lookup_code = val.lookup_code AND acc.security_group_id = val.security_group_id AND acc.view_application_id = val.view_application_id AND val.language = asg_base.get_language

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, VAL.LOOKUP_TYPE
, VAL.LOOKUP_CODE
, VAL.MEANING
, VAL.DESCRIPTION
, VAL.VIEW_APPLICATION_ID
, VAL.SECURITY_GROUP_ID
, VAL.LANGUAGE
, VAL.ENABLED_FLAG
, VAL.START_DATE_ACTIVE
, VAL.END_DATE_ACTIVE
, VAL.TERRITORY_CODE
, VAL.TAG
FROM FND_LOOKUP_VALUES VAL
, CSM_LOOKUPS_ACC ACC
WHERE ACC.LOOKUP_TYPE = VAL.LOOKUP_TYPE
AND ACC.LANGUAGE = VAL.LANGUAGE
AND ACC.LOOKUP_CODE = VAL.LOOKUP_CODE
AND ACC.SECURITY_GROUP_ID = VAL.SECURITY_GROUP_ID
AND ACC.VIEW_APPLICATION_ID = VAL.VIEW_APPLICATION_ID
AND VAL.LANGUAGE = ASG_BASE.GET_LANGUAGE