DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_DIM_HIERARCHY

Line 1486: mth_dim_hierarchy mdh,

1482: mdh.HIERARCHY_NAME,
1483: mss.SYSTEM_PK as SYSTEM_FK,
1484: P_SESSION_NO as RUN_ID
1485: FROM mth_week_d s,
1486: mth_dim_hierarchy mdh,
1487: mth_systems_setup mss
1488: WHERE mdh.hierarchy_id = s.hierarchy_id
1489: and mdh.dimension_name = 'TIME'
1490: and s.system_fk_key = mss.system_pk_key)e

Line 1543: mth_dim_hierarchy mdh,

1539: mdh.HIERARCHY_NAME,
1540: mss.SYSTEM_PK as SYSTEM_FK,
1541: P_SESSION_NO as RUN_ID
1542: FROM mth_period_d s,
1543: mth_dim_hierarchy mdh,
1544: mth_systems_setup mss
1545: WHERE mdh.hierarchy_id = s.hierarchy_id
1546: and mdh.dimension_name = 'TIME'
1547: and s.system_fk_key = mss.system_pk_key)e

Line 1600: mth_dim_hierarchy mdh,

1596: mdh.HIERARCHY_NAME,
1597: mss.SYSTEM_PK as SYSTEM_FK,
1598: P_SESSION_NO as RUN_ID
1599: FROM mth_quarter_d s,
1600: mth_dim_hierarchy mdh,
1601: mth_systems_setup mss
1602: WHERE mdh.hierarchy_id = s.hierarchy_id
1603: and mdh.dimension_name = 'TIME'
1604: and s.system_fk_key = mss.system_pk_key)e

Line 1657: mth_dim_hierarchy mdh,

1653: mdh.HIERARCHY_NAME,
1654: mss.SYSTEM_PK as SYSTEM_FK,
1655: P_SESSION_NO as RUN_ID
1656: FROM mth_year_d s,
1657: mth_dim_hierarchy mdh,
1658: mth_systems_setup mss
1659: WHERE mdh.hierarchy_id = s.hierarchy_id
1660: and mdh.dimension_name = 'TIME'
1661: and s.system_fk_key = mss.system_pk_key)e