Product: | FF - FastFormula |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.FF_GLOBALS_F_V |
SELECT GLB.ROWID ROW_ID
, GLB.GLOBAL_ID
, GLB.EFFECTIVE_START_DATE
, GLB.EFFECTIVE_END_DATE
, GLB.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, GLB.LEGISLATION_CODE
, GLB.DATA_TYPE
, GLB.GLOBAL_NAME
, GLB.GLOBAL_DESCRIPTION
, GLB.GLOBAL_VALUE
, GLB.LAST_UPDATE_DATE
, GLB.LAST_UPDATED_BY
, GLB.LAST_UPDATE_LOGIN
, GLB.CREATED_BY
, GLB.CREATION_DATE
, HLU.MEANING DATA_TYPE_MEANING
FROM FF_GLOBALS_F GLB
, HR_LOOKUPS HLU
, FND_SESSIONS SES
WHERE HLU.LOOKUP_TYPE = 'DATA_TYPE'
AND HLU.LOOKUP_CODE = GLB.DATA_TYPE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN GLB.EFFECTIVE_START_DATE
AND GLB.EFFECTIVE_END_DATE