DBA Data[Home] [Help]

APPS.MTH_EQUIPMENT_PKG dependencies on MTH_DIM_HIERARCHY

Line 1513: FROM MTH_EQUIPMENTS_D ME,MTH_DIM_HIERARCHY MDM

1509: v_unassigned_val PARENT_FK_KEY,
1510: To_Date('01-01-1900','DD-MM-YYYY') EFFECTIVE_DATE,
1511: ME.EQUIPMENT_NAME EQUIPMENT_NAME,
1512: MTH_UTIL_PKG.MTH_UA_GET_MEANING() PARENT_NAME
1513: FROM MTH_EQUIPMENTS_D ME,MTH_DIM_HIERARCHY MDM
1514: WHERE MDM.DIMENSION_NAME = 'EQUIPMENT'
1515: )CATCH_ALL
1516:
1517: ON (

Line 1579: FROM MTH_DIM_HIERARCHY MDH

1575: , 'Unassigned' AS LEVEL_NAME
1576: , -99999 AS PARENT_KEY
1577: , 'Unassigned' AS PARENT_NAME
1578: , MDH.HIERARCHY_ID
1579: FROM MTH_DIM_HIERARCHY MDH
1580: CROSS JOIN cntr c
1581: WHERE MDH.CREATION_DATE >= v_log_from_date
1582: AND MDH.DIMENSION_NAME = 'EQUIPMENT')UN_ALL
1583: ON (