Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_CLASSCODE_RELATIONS_V |
SELECT FND_LOOKUP_VALUES.LOOKUP_TYPE
, FND_LOOKUP_VALUES.LOOKUP_CODE
, FND_LOOKUP_VALUES.MEANING
, FND_LOOKUP_VALUES.DESCRIPTION
, FND_LOOKUP_VALUES.START_DATE_ACTIVE
, FND_LOOKUP_VALUES.END_DATE_ACTIVE
, FND_LOOKUP_VALUES.ENABLED_FLAG
, HZ_CLASS_CODE_RELATIONS.CLASS_CATEGORY
, HZ_CLASS_CODE_RELATIONS.CLASS_CODE
, HZ_CLASS_CODE_RELATIONS.SUB_CLASS_CODE
, HZ_CLASS_CODE_RELATIONS.LAST_UPDATE_LOGIN
, HZ_CLASS_CODE_RELATIONS.CREATED_BY
, HZ_CLASS_CODE_RELATIONS.CREATION_DATE
, HZ_CLASS_CODE_RELATIONS.LAST_UPDATE_DATE
, HZ_CLASS_CODE_RELATIONS.LAST_UPDATED_BY
, HZ_CLASS_CODE_RELATIONS.CREATED_BY_MODULE
, HZ_CLASS_CODE_RELATIONS.APPLICATION_ID
, HZ_CLASS_CODE_RELATIONS.OBJECT_VERSION_NUMBER
, FND_LOOKUP_VALUES.LANGUAGE
, FND_LOOKUP_VALUES.VIEW_APPLICATION_ID
, FND_LOOKUP_VALUES.SECURITY_GROUP_ID
FROM FND_LOOKUP_VALUES
, HZ_CLASS_CODE_RELATIONS
WHERE FND_LOOKUP_VALUES.LOOKUP_TYPE = HZ_CLASS_CODE_RELATIONS.CLASS_CATEGORY(+)
AND FND_LOOKUP_VALUES.LOOKUP_CODE = HZ_CLASS_CODE_RELATIONS.SUB_CLASS_CODE(+)