DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 5552: AHL_MC_PATH_POSITION_NODES NODE,

5548: AHL_BUILD_GOALS BG,
5549: AHL_VISITS_B AVB,
5550: AHL_MR_HEADERS_B MR,
5551: AHL_MR_EFFECTIVITIES EFF,
5552: AHL_MC_PATH_POSITION_NODES NODE,
5553: AHL_MC_HEADERS_B MC,
5554: AHL_UNIT_CONFIG_HEADERS UCH
5555: WHERE INTV.COUNTER_ID = CNTR.COUNTER_ID
5556: AND UOM.UOM_CODE = CNTR.UOM_CODE

Line 5577: FROM AHL_MC_PATH_POSITION_NODES PPN

5573: AND MC.MC_ID = NODE.MC_ID
5574: AND NVL(NODE.VERSION_NUMBER,MC.VERSION_NUMBER) = MC.VERSION_NUMBER
5575: AND AVB.VISIT_ID = ASM.VISIT_ID
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