VIEW: APPS.FEM_CAL_PERIODS_BY_LEDGER_V

Source

View Text - Preformatted

SELECT c.cal_period_id, c.dimension_group_id, c.calendar_id, c.cal_period_name, c.description, l.ledger_id, l.ledger_display_code FROM fem_ledgers_b l, fem_ledgers_attr la, fem_dim_attributes_b da, fem_dimensions_b d, fem_dim_attr_versions_b v, fem_hierarchies h, fem_object_definition_b o, fem_cal_periods_vl c WHERE l.enabled_flag = 'Y' AND l.personal_flag = 'N' AND l.ledger_id = la.ledger_id AND la.attribute_id = da.attribute_id AND da.attribute_varchar_label = 'CAL_PERIOD_HIER_OBJ_DEF_ID' AND v.version_id = la.version_id AND v.default_version_flag = 'Y' AND da.dimension_id = d.dimension_id AND d.dimension_varchar_label = 'LEDGER' AND la.dim_attribute_numeric_member = o.object_definition_id AND o.object_id = h.hierarchy_obj_id AND c.calendar_id = h.calendar_id AND c.enabled_flag = 'Y' AND c.personal_flag = 'N'

View Text - HTML Formatted

SELECT C.CAL_PERIOD_ID
, C.DIMENSION_GROUP_ID
, C.CALENDAR_ID
, C.CAL_PERIOD_NAME
, C.DESCRIPTION
, L.LEDGER_ID
, L.LEDGER_DISPLAY_CODE
FROM FEM_LEDGERS_B L
, FEM_LEDGERS_ATTR LA
, FEM_DIM_ATTRIBUTES_B DA
, FEM_DIMENSIONS_B D
, FEM_DIM_ATTR_VERSIONS_B V
, FEM_HIERARCHIES H
, FEM_OBJECT_DEFINITION_B O
, FEM_CAL_PERIODS_VL C
WHERE L.ENABLED_FLAG = 'Y'
AND L.PERSONAL_FLAG = 'N'
AND L.LEDGER_ID = LA.LEDGER_ID
AND LA.ATTRIBUTE_ID = DA.ATTRIBUTE_ID
AND DA.ATTRIBUTE_VARCHAR_LABEL = 'CAL_PERIOD_HIER_OBJ_DEF_ID'
AND V.VERSION_ID = LA.VERSION_ID
AND V.DEFAULT_VERSION_FLAG = 'Y'
AND DA.DIMENSION_ID = D.DIMENSION_ID
AND D.DIMENSION_VARCHAR_LABEL = 'LEDGER'
AND LA.DIM_ATTRIBUTE_NUMERIC_MEMBER = O.OBJECT_DEFINITION_ID
AND O.OBJECT_ID = H.HIERARCHY_OBJ_ID
AND C.CALENDAR_ID = H.CALENDAR_ID
AND C.ENABLED_FLAG = 'Y'
AND C.PERSONAL_FLAG = 'N'