DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 784: FROM MTL_Units_Of_Measure_vl UOM, CS_Counters C, Ahl_MR_Intervals_APP_V MRI

780:
781: -- To find task's unit effectivity unit of measure related information
782: /* CURSOR c_unitofmeasure (l_tol_before IN NUMBER, l_tol_after IN NUMBER) IS
783: SELECT UOM.Unit_of_Measure
784: FROM MTL_Units_Of_Measure_vl UOM, CS_Counters C, Ahl_MR_Intervals_APP_V MRI
785: WHERE UOM.Uom_Code = C.Uom_Code AND C.Counter_Id = MRI.Counter_Id AND
786: Tolerance_Before = l_tol_before AND Tolerance_After = l_tol_after;
787: */
788: -- AnRaj: Changed query for perf issue#5, Bug 4919465

Line 791: FROM MTL_Units_Of_Measure UOM,

787: */
788: -- AnRaj: Changed query for perf issue#5, Bug 4919465
789: CURSOR c_unitofmeasure (p_interval_id IN NUMBER) IS
790: SELECT UOM.Unit_of_Measure
791: FROM MTL_Units_Of_Measure UOM,
792: csi_counter_template_b C,
793: AHL_MR_INTERVALS MRI
794: WHERE UOM.Uom_Code = C.Uom_Code
795: AND C.Counter_Id = MRI.Counter_Id