VIEW: APPS.PER_CALENDAR_ENTRIES_V

Source

View Text - Preformatted

SELECT ENT.CALENDAR_ENTRY_ID ,ENT.BUSINESS_GROUP_ID ,ENT.NAME ,ENT.TYPE ,ENT.START_DATE ,ENT.START_HOUR ,ENT.START_MIN ,ENT.END_DATE ,ENT.END_HOUR ,ENT.END_MIN ,ENT.DESCRIPTION ,ENT.HIERARCHY_ID ,PGH.NAME ,ENT.VALUE_SET_ID ,FND.FLEX_VALUE_SET_NAME ,ENT.LAST_UPDATE_DATE ,ENT.LAST_UPDATED_BY ,ENT.LAST_UPDATE_LOGIN ,ENT.CREATED_BY ,ENT.CREATION_DATE ,ENT.OBJECT_VERSION_NUMBER ,ENT.LEGISLATION_CODE ,ENT.IDENTIFIER_KEY ,ENT.ORGANIZATION_STRUCTURE_ID ,OS.NAME ,ENT.ORG_STRUCTURE_VERSION_ID FROM PER_CALENDAR_ENTRIES ENT, FND_FLEX_VALUE_SETS FND, PER_GEN_HIERARCHY PGH, PER_ORGANIZATION_STRUCTURES OS WHERE ENT.VALUE_SET_ID = FND.FLEX_VALUE_SET_ID(+) AND ENT.HIERARCHY_ID = PGH.HIERARCHY_ID(+) AND ENT.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID(+)

View Text - HTML Formatted

SELECT ENT.CALENDAR_ENTRY_ID
, ENT.BUSINESS_GROUP_ID
, ENT.NAME
, ENT.TYPE
, ENT.START_DATE
, ENT.START_HOUR
, ENT.START_MIN
, ENT.END_DATE
, ENT.END_HOUR
, ENT.END_MIN
, ENT.DESCRIPTION
, ENT.HIERARCHY_ID
, PGH.NAME
, ENT.VALUE_SET_ID
, FND.FLEX_VALUE_SET_NAME
, ENT.LAST_UPDATE_DATE
, ENT.LAST_UPDATED_BY
, ENT.LAST_UPDATE_LOGIN
, ENT.CREATED_BY
, ENT.CREATION_DATE
, ENT.OBJECT_VERSION_NUMBER
, ENT.LEGISLATION_CODE
, ENT.IDENTIFIER_KEY
, ENT.ORGANIZATION_STRUCTURE_ID
, OS.NAME
, ENT.ORG_STRUCTURE_VERSION_ID
FROM PER_CALENDAR_ENTRIES ENT
, FND_FLEX_VALUE_SETS FND
, PER_GEN_HIERARCHY PGH
, PER_ORGANIZATION_STRUCTURES OS
WHERE ENT.VALUE_SET_ID = FND.FLEX_VALUE_SET_ID(+)
AND ENT.HIERARCHY_ID = PGH.HIERARCHY_ID(+)
AND ENT.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID(+)