VIEW: APPS.FF_GLOBALS_F_FV

Source

View Text - Preformatted

SELECT B.ROW_ID, B.GLOBAL_ID, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.BUSINESS_GROUP_ID, B.LEGISLATION_CODE, B.DATA_TYPE, B.GLOBAL_VALUE, B.BASE_GLOBAL_NAME, B.BASE_GLOBAL_DESCRIPTION, B.GLOBAL_NAME, B.GLOBAL_DESCRIPTION, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, HLU.MEANING DATA_TYPE_MEANING, B.OBJECT_VERSION_NUMBER FROM FF_GLOBALS_F_VL B, HR_LOOKUPS HLU, FND_SESSIONS SES WHERE HLU.LOOKUP_TYPE = 'DATA_TYPE' AND HLU.LOOKUP_CODE = B.DATA_TYPE AND SES.SESSION_ID=USERENV('SESSIONID') AND SES.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT B.ROW_ID
, B.GLOBAL_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.DATA_TYPE
, B.GLOBAL_VALUE
, B.BASE_GLOBAL_NAME
, B.BASE_GLOBAL_DESCRIPTION
, B.GLOBAL_NAME
, B.GLOBAL_DESCRIPTION
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, HLU.MEANING DATA_TYPE_MEANING
, B.OBJECT_VERSION_NUMBER
FROM FF_GLOBALS_F_VL B
, HR_LOOKUPS HLU
, FND_SESSIONS SES
WHERE HLU.LOOKUP_TYPE = 'DATA_TYPE'
AND HLU.LOOKUP_CODE = B.DATA_TYPE
AND SES.SESSION_ID=USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE