DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on MTL_UNITS_OF_MEASURE

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

898:
899: -- To find task's unit effectivity unit of measure related information
900: /* CURSOR c_unitofmeasure (l_tol_before IN NUMBER, l_tol_after IN NUMBER) IS
901: SELECT UOM.Unit_of_Measure
902: FROM MTL_Units_Of_Measure_vl UOM, CS_Counters C, Ahl_MR_Intervals_APP_V MRI
903: WHERE UOM.Uom_Code = C.Uom_Code AND C.Counter_Id = MRI.Counter_Id AND
904: Tolerance_Before = l_tol_before AND Tolerance_After = l_tol_after;
905: */
906: -- AnRaj: Changed query for perf issue#5, Bug 4919465

Line 909: FROM MTL_Units_Of_Measure UOM,

905: */
906: -- AnRaj: Changed query for perf issue#5, Bug 4919465
907: CURSOR c_unitofmeasure (p_interval_id IN NUMBER) IS
908: SELECT UOM.Unit_of_Measure
909: FROM MTL_Units_Of_Measure UOM,
910: csi_counter_template_b C,
911: AHL_MR_INTERVALS MRI
912: WHERE UOM.Uom_Code = C.Uom_Code
913: AND C.Counter_Id = MRI.Counter_Id