DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_MR_INTERVALS

Line 5545: AHL_MR_INTERVALS INTV,

5541: END MAX_COUNTER_VALUE,
5542: MR.TITLE MR_TITLE,
5543: MR.MR_HEADER_ID MR_HEADER_ID
5544: FROM AHL_SCHEDULE_MATERIALS ASM,
5545: AHL_MR_INTERVALS INTV,
5546: CS_COUNTERS CNTR,
5547: MTL_UNITS_OF_MEASURE_VL UOM,
5548: AHL_BUILD_GOALS BG,
5549: AHL_VISITS_B AVB,

Line 5580: FROM AHL_MR_INTERVALS THR, CS_COUNTERS CS

5576: AND NODE.sequence = (SELECT MAX(PPN.sequence)
5577: FROM AHL_MC_PATH_POSITION_NODES PPN
5578: WHERE PPN.PATH_POSITION_ID = NODE.PATH_POSITION_ID)
5579: AND INTV.INTERVAL_VALUE IN (SELECT MIN(THR.INTERVAL_VALUE)
5580: FROM AHL_MR_INTERVALS THR, CS_COUNTERS CS
5581: WHERE THR.MR_EFFECTIVITY_ID = INTV.MR_EFFECTIVITY_ID
5582: AND CS.COUNTER_ID = THR.COUNTER_ID
5583: GROUP BY CS.UOM_CODE)
5584: --PC Node effectivities