DBA Data[Home] [Help]

APPS.MTH_LOAD_TAG_READINGS_PKG dependencies on MTH_PLANTS_D

Line 878: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS

874: MCM.CONTEXTUALIZE_METHOD = 1 AND
875: STG.MTH_ENTITY IS NOT NULL AND
876: STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) ) BUS
877: GROUP BY
878: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
879: WHERE
880: TAG_DATA.GROUP_ID = BUS_CONTEXT.GROUP_ID (+) And
881: TAG_DATA.EQUIPMENT_FK_KEY = BUS_CONTEXT.EQUIPMENT_FK_KEY (+) And
882: TAG_DATA.PLANT_FK_KEY = PLANTS.PLANT_PK_KEY (+) And

Line 1108: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS

1104: MCM.CONTEXTUALIZE_METHOD = 1 AND
1105: STG.MTH_ENTITY IS NOT NULL AND
1106: STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) ) BUS
1107: GROUP BY
1108: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1109: WHERE
1110: TAG_DATA.GROUP_ID = BUS_CONTEXT.GROUP_ID (+) And
1111: TAG_DATA.EQUIPMENT_FK_KEY = BUS_CONTEXT.EQUIPMENT_FK_KEY (+) And
1112: TAG_DATA.PLANT_FK_KEY = PLANTS.PLANT_PK_KEY (+) And