eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_CREATE_BATCH_PVT dependencies on INV_CONVERT

Line 354: SELECT SUM (inv_convert.inv_um_convert (v_inventory_item_id

350: --sunitha bug # 5484529 selecting the sum of the plan quantity without converting
351: --it to the user entered UOM while creating the batch
352: CURSOR cur_batch_qty (v_batch_id NUMBER, v_inventory_item_id NUMBER)
353: IS
354: SELECT SUM (inv_convert.inv_um_convert (v_inventory_item_id
355: ,5
356: ,plan_qty
357: ,dtl_um
358: ,p_batch_size_uom

Line 711: inv_convert.inv_um_convert

707:
708: IF (l_material_details (l_number_of_formula_lines).dtl_um <>
709: l_item_master.primary_uom_code) THEN
710: l_temp_qty :=
711: inv_convert.inv_um_convert
712: (l_material_details (l_number_of_formula_lines).inventory_item_id
713: ,5
714: ,l_material_details (l_number_of_formula_lines).original_qty
715: ,l_material_details (l_number_of_formula_lines).dtl_um

Line 839: inv_convert.inv_um_convert

835: l_recipe_validity_rule.inventory_item_id THEN
836:
837: -- 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.
838: l_temp_qty :=
839: inv_convert.inv_um_convert
840: (l_material_details (loop_count).inventory_item_id
841: ,32 --5
842: ,l_material_details (loop_count).plan_qty
843: ,l_material_details (loop_count).dtl_um

Line 923: inv_convert.inv_um_convert

919:
920: -- 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.
921:
922: l_temp_qty :=
923: inv_convert.inv_um_convert
924: (l_material_details (loop_count).inventory_item_id
925: ,32 --5
926: ,l_material_details (loop_count).plan_qty
927: ,l_material_details (loop_count).dtl_um

Line 1026: inv_convert.inv_um_convert

1022: l_total_output_qty_c
1023: + l_material_details (loop_count).plan_qty;
1024: ELSE
1025: l_temp_qty :=
1026: inv_convert.inv_um_convert
1027: (l_material_details (loop_count).inventory_item_id
1028: ,5
1029: ,l_material_details (loop_count).plan_qty
1030: ,l_material_details (loop_count).dtl_um

Line 1114: l_temp_qty := inv_convert.inv_um_convert

1110: ,l_material_details (loop_count).organization_id);
1111: FETCH production_rules_cursor INTO l_production_rule_qty, l_production_um;
1112: CLOSE production_rules_cursor;
1113: IF (l_material_details (loop_count).dtl_um <> l_production_um) THEN
1114: l_temp_qty := inv_convert.inv_um_convert
1115: (l_material_details (loop_count).inventory_item_id
1116: ,5
1117: ,l_material_details (loop_count).original_qty
1118: ,l_material_details (loop_count).dtl_um

Line 1146: inv_convert.inv_um_convert

1142: l_total_output_qty_b
1143: + l_material_details (loop_count).plan_qty;
1144: ELSE
1145: l_temp_qty :=
1146: inv_convert.inv_um_convert
1147: (l_material_details (loop_count).inventory_item_id
1148: ,5
1149: ,l_material_details (loop_count).plan_qty
1150: ,l_material_details (loop_count).dtl_um

Line 1243: inv_convert.inv_um_convert

1239: l_total_output_qty_b
1240: + l_material_details (l_row_count).plan_qty;
1241: ELSE
1242: l_temp_qty :=
1243: inv_convert.inv_um_convert
1244: (l_material_details (l_row_count).inventory_item_id
1245: ,5
1246: ,l_material_details (l_row_count).plan_qty
1247: ,l_material_details (l_row_count).dtl_um

Line 1713: inv_convert.inv_um_convert

1709: ELSE
1710: /* routing count = 0... there are no steps, so calculate the dates with prod rules if they exist... */
1711: IF l_prim_prod_found THEN
1712: l_temp_qty :=
1713: inv_convert.inv_um_convert
1714: (l_recipe_validity_rule.inventory_item_id
1715: ,5
1716: ,l_prim_prod_qty
1717: ,l_prim_prod_um

Line 2077: l_temp_qty := inv_convert.inv_um_convert

2073: END IF;
2074:
2075: /*if the new item uom is not the primary uom then calculate the primary quantity*/
2076: IF l_formula_tbl(1).detail_uom <> l_new_item_rec.primary_uom_code THEN
2077: l_temp_qty := inv_convert.inv_um_convert
2078: (item_id => l_material_details(l_row_count).inventory_item_id
2079: ,precision => 5
2080: ,from_quantity => l_material_details(l_row_count).plan_qty
2081: ,from_unit => l_material_details(l_row_count).dtl_um

Line 2232: /* IF (ROUND (inv_convert.inv_um_convert (l_recipe_validity_rule.inventory_item_id

2228: --to the Routing uom and then Compare it with the l_temp_qty.
2229:
2230: -- Bug 6665602 Back out 5484529... Reinstate original condition.
2231: IF (ROUND (p_batch_size, 5) <> ROUND (l_temp_qty, 5) ) THEN
2232: /* IF (ROUND (inv_convert.inv_um_convert (l_recipe_validity_rule.inventory_item_id
2233: ,5
2234: ,p_batch_size
2235: ,p_batch_size_uom
2236: ,l_recipe_validity_rule.detail_uom

Line 2629: inv_convert.inv_um_convert

2625:
2626: SELECT
2627: (frh.routing_qty * NVL(frd.minimum_transfer_qty,0)
2628: * DECODE(fmd.detail_uom, iim.primary_uom_code, fmd.qty,
2629: inv_convert.inv_um_convert
2630: (fmd.inventory_item_id,
2631: 5,
2632: fmd.qty,
2633: fmd.detail_uom,