[Home] [Help]
462: CURSOR cur_batch_qty (v_batch_id NUMBER
463: ,v_inventory_item_id NUMBER
464: ,v_sum_all_prod_lines VARCHAR)
465: IS
466: SELECT SUM (inv_convert.inv_um_convert (v_inventory_item_id
467: ,5
468: ,plan_qty
469: ,dtl_um
470: ,p_batch_size_uom
475: AND inventory_item_id = v_inventory_item_id
476: AND line_type = gme_common_pvt.g_line_type_prod
477: AND v_sum_all_prod_lines = 'A'
478: UNION
479: SELECT inv_convert.inv_um_convert (v_inventory_item_id
480: ,5
481: ,plan_qty
482: ,dtl_um
483: ,p_batch_size_uom
879: -- Bug 7578476 - Use correct primary UOM to derive original_primary_qty.
880: IF (l_material_details (l_number_of_formula_lines).dtl_um <>
881: l_item_masters(l_number_of_formula_lines).primary_uom_code) THEN
882: l_temp_qty :=
883: inv_convert.inv_um_convert
884: (l_material_details (l_number_of_formula_lines).inventory_item_id
885: ,5
886: ,l_material_details (l_number_of_formula_lines).original_qty
887: ,l_material_details (l_number_of_formula_lines).dtl_um
1007: -- bug#5373369 nsinghi rework. While determining the scale factor, give higher precision,
1008: -- otherwise when converting back to batch UOM, there is decimal dust issue and batch
1009: -- creation fails.
1010: l_temp_qty :=
1011: inv_convert.inv_um_convert
1012: (l_material_details (loop_count).inventory_item_id
1013: ,32 --5
1014: ,l_material_details (loop_count).plan_qty
1015: ,l_material_details (loop_count).dtl_um
1084:
1085: -- bug#5373369 nsinghi rework. While determining the scale factor, give higher precision, otherwise when converting back to batch UOM, there is decimal dust issue and batch creation fails.
1086:
1087: l_temp_qty :=
1088: inv_convert.inv_um_convert
1089: (l_material_details (loop_count).inventory_item_id
1090: ,32 --5
1091: ,l_material_details (loop_count).plan_qty
1092: ,l_material_details (loop_count).dtl_um
1187: l_total_output_qty_c
1188: + l_material_details (loop_count).plan_qty;
1189: ELSE
1190: l_temp_qty :=
1191: inv_convert.inv_um_convert
1192: (l_material_details (loop_count).inventory_item_id
1193: ,32 -- Bug 16474091 - change precision from 5 to 32
1194: ,l_material_details (loop_count).plan_qty
1195: ,l_material_details (loop_count).dtl_um
1278:
1279: -- Bug 7578476 - Use already loaded primary UOM to derive original_primary_qty.
1280: -- Remove unnecessary fetch using cursor production_rules_cursor.
1281: IF (l_material_details (loop_count).dtl_um <> l_item_masters(loop_count).primary_uom_code) THEN
1282: l_temp_qty := inv_convert.inv_um_convert
1283: (l_material_details (loop_count).inventory_item_id
1284: ,5
1285: ,l_material_details (loop_count).original_qty
1286: ,l_material_details (loop_count).dtl_um
1350: l_total_output_qty_b
1351: + l_material_details (loop_count).plan_qty;
1352: ELSE
1353: l_temp_qty :=
1354: inv_convert.inv_um_convert
1355: (l_material_details (loop_count).inventory_item_id
1356: ,32 -- Bug 16474091 - change precision from 5 to 32
1357: ,l_material_details (loop_count).plan_qty
1358: ,l_material_details (loop_count).dtl_um
1431: -- 7578476 - Initialize original_primary_qty properly.
1432: IF (l_material_details (l_row_count).dtl_um <>
1433: l_item_masters(l_row_count).primary_uom_code) THEN
1434: l_material_details (l_row_count).original_primary_qty :=
1435: inv_convert.inv_um_convert
1436: (l_material_details (l_row_count).inventory_item_id
1437: ,5
1438: ,l_material_details (l_row_count).original_qty
1439: ,l_material_details (l_row_count).dtl_um
1468: l_total_output_qty_b
1469: + l_material_details (l_row_count).plan_qty;
1470: ELSE
1471: l_temp_qty :=
1472: inv_convert.inv_um_convert
1473: (l_material_details (l_row_count).inventory_item_id
1474: ,5
1475: ,l_material_details (l_row_count).plan_qty
1476: ,l_material_details (l_row_count).dtl_um
1938: ELSE
1939: /* routing count = 0... there are no steps, so calculate the dates with prod rules if they exist... */
1940: IF l_prim_prod_found THEN
1941: l_temp_qty :=
1942: inv_convert.inv_um_convert
1943: (l_recipe_validity_rule.inventory_item_id
1944: ,5
1945: ,l_prim_prod_qty
1946: ,l_prim_prod_um
2331: END IF;
2332:
2333: /*if the new item uom is not the primary uom then calculate the primary quantity*/
2334: IF l_formula_tbl(1).detail_uom <> l_new_item_rec.primary_uom_code THEN
2335: l_temp_qty := inv_convert.inv_um_convert
2336: (item_id => l_material_details(l_row_count).inventory_item_id
2337: ,precision => 5
2338: ,from_quantity => l_material_details(l_row_count).plan_qty
2339: ,from_unit => l_material_details(l_row_count).dtl_um
2500: -- zero qty phantom batches to be created.
2501: IF l_temp_qty <> 0 THEN
2502: IF ((p_batch_size / l_temp_qty) < .999 ) THEN
2503: -- IF (ROUND (p_batch_size, 4) <> ROUND (l_temp_qty, 4) ) THEN
2504: /* IF (ROUND (inv_convert.inv_um_convert (l_recipe_validity_rule.inventory_item_id
2505: ,5
2506: ,p_batch_size
2507: ,p_batch_size_uom
2508: ,l_recipe_validity_rule.detail_uom
2925: /*
2926: SELECT
2927: (frh.routing_qty * NVL(frd.minimum_transfer_qty,0)
2928: * DECODE(fmd.detail_uom, iim.primary_uom_code, fmd.qty,
2929: inv_convert.inv_um_convert
2930: (fmd.inventory_item_id,
2931: 5,
2932: fmd.qty,
2933: fmd.detail_uom,
2939: */
2940: SELECT
2941: (frh.routing_qty * NVL(frd.minimum_transfer_qty,0)
2942: * DECODE(fmd.detail_uom, iim.primary_uom_code, fmd.qty,
2943: inv_convert.inv_um_convert
2944: (fmd.inventory_item_id,
2945: 5,
2946: fmd.qty,
2947: fmd.detail_uom,