APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1088: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table

1084: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W
1085: WHERE W.VISIT_TASK_ID = T.VISIT_TASK_ID AND T.VISIT_ID = V.VISIT_ID
1086: AND W.VISIT_TASK_ID = x_id;
1087:
1088: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
1089: CURSOR c_UOM (x_name IN VARCHAR2) IS
1090: SELECT UOM_CODE
1091: FROM MTL_UNITS_OF_MEASURE
1092: WHERE UNIT_OF_MEASURE = x_name;

Line 1091: FROM MTL_UNITS_OF_MEASURE

1087:
1088: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
1089: CURSOR c_UOM (x_name IN VARCHAR2) IS
1090: SELECT UOM_CODE
1091: FROM MTL_UNITS_OF_MEASURE
1092: WHERE UNIT_OF_MEASURE = x_name;
1093: -- Get uom from bom resources
1094: CURSOR c_uom_code (x_id IN NUMBER)
1095: IS

Line 2181: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table

2177: SELECT DEPARTMENT_ID FROM
2178: BOM_DEPARTMENT_RESOURCES
2179: WHERE RESOURCE_ID = x_id;
2180:
2181: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
2182: CURSOR c_UOM (x_name IN VARCHAR2) IS
2183: SELECT UOM_CODE
2184: FROM MTL_UNITS_OF_MEASURE
2185: WHERE UNIT_OF_MEASURE = x_name;

Line 2184: FROM MTL_UNITS_OF_MEASURE

2180:
2181: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
2182: CURSOR c_UOM (x_name IN VARCHAR2) IS
2183: SELECT UOM_CODE
2184: FROM MTL_UNITS_OF_MEASURE
2185: WHERE UNIT_OF_MEASURE = x_name;
2186:
2187: -- Get uom from bom resources
2188: CURSOR c_uom_code (x_id IN NUMBER)

Line 3075: MTL_UNITS_OF_MEASURE MUOM,

3071: MUOM.UNIT_OF_MEASURE UOM_NAME,
3072: AWO.workorder_id job_id
3073: FROM
3074: BOM_RESOURCES BOM,
3075: MTL_UNITS_OF_MEASURE MUOM,
3076: AHL_OPERATION_RESOURCES AOR,
3077: AHL_WORKORDER_OPERATIONS AWO
3078: WHERE
3079: AOR.OPERATION_RESOURCE_ID = x_id AND