[Home] [Help]
341: END IF;
342:
343: if(p_count_uom <> inv_cache.item_rec.primary_uom_code) then
344: g_count_uom := inv_cache.item_rec.primary_uom_code;
345: g_count_quantity := inv_convert.inv_um_convert ( p_inventory_item_id,
346: p_lot_number,
347: p_organization_id,
348: 5,
349: p_count_quantity,
1074: IF ( l_debug = 1 ) THEN
1075: print_debug('g_cc_entry.count_quantity_current: ' || g_cc_entry.count_quantity_current);
1076: END IF;
1077:
1078: l_current_quantity := inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1079: 5,
1080: g_cc_entry.count_quantity_current,
1081: g_cc_entry.count_uom_current, --same as g_count_uom, should be primary_uom
1082: g_orig_count_uom, --transaction_uom
1085: );
1086: IF ( l_debug = 1 ) THEN
1087: print_debug('l_current_quantity: ' || l_current_quantity);
1088: END IF;
1089: l_current_quantity_prim := inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1090: 5,
1091: l_current_quantity,
1092: g_orig_count_uom, --transaction_uom
1093: g_cc_entry.count_uom_current, --same as g_count_uom, should be primary_uom
1097: IF ( l_debug = 1 ) THEN
1098: print_debug('l_current_quantity_prim: ' || l_current_quantity_prim);
1099: print_debug('g_cc_entry.adjustment_quantity: ' || g_cc_entry.adjustment_quantity);
1100: END IF;
1101: l_adjustment_quantity := inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1102: 5,
1103: g_cc_entry.adjustment_quantity,
1104: g_cc_entry.count_uom_current, --same as g_count_uom, should be primary_uom
1105: g_orig_count_uom, --transaction_uom
1108: );
1109: IF ( l_debug = 1 ) THEN
1110: print_debug('l_adjustment_quantity: ' || l_adjustment_quantity);
1111: END IF;
1112: l_adjustment_quantity_prim := inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1113: 5,
1114: l_adjustment_quantity,
1115: g_orig_count_uom, --transaction_uom
1116: g_cc_entry.count_uom_current, --same as g_count_uom, should be primary_uom
1647: AND organization_id = g_cc_entry.organization_id;
1648:
1649: -- Convert the count quantity into the item primary uom quantity
1650: l_primary_uom_quantity :=
1651: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1652: 6,
1653: g_count_quantity,
1654: g_count_uom,
1655: l_primary_uom,
1903: AND organization_id = g_cc_entry.organization_id;
1904:
1905: -- Convert the system quantity into the count uom
1906: /*2977228l_system_quantity :=
1907: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1908: 6,
1909: l_system_quantity,
1910: l_primary_uom,
1911: g_count_uom,
2386: AND organization_id = g_cc_entry.organization_id;
2387:
2388: -- Convert the system quantity into the count uom
2389: /*2977228l_system_quantity :=
2390: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2391: 6,
2392: l_system_quantity,
2393: l_primary_uom,
2394: g_count_uom,
2396: NULL
2397: );*/
2398: -- Convert the count quantity into the item primary uom quantity
2399: l_primary_uom_quantity :=
2400: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2401: 6,
2402: g_count_quantity,
2403: g_count_uom,
2404: l_primary_uom,
2478: AND organization_id = g_cc_entry.organization_id;
2479:
2480: -- Convert the system quantity into the count uom
2481: /*2977228l_system_quantity :=
2482: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2483: 6,
2484: l_system_quantity,
2485: l_primary_uom,
2486: g_count_uom,
2488: NULL
2489: );*/
2490: -- Convert the count quantity into the item primary uom quantity
2491: l_primary_uom_quantity :=
2492: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2493: 6,
2494: g_count_quantity,
2495: g_count_uom,
2496: l_primary_uom,
2575: AND organization_id = g_cc_entry.organization_id;
2576:
2577: -- Convert the system quantity into the count uom
2578: /*2977228l_system_quantity :=
2579: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2580: 6,
2581: l_system_quantity,
2582: l_primary_uom,
2583: g_count_uom,
2585: NULL
2586: );*/
2587: -- Convert the count quantity into the item primary uom quantity
2588: l_primary_uom_quantity :=
2589: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2590: 6,
2591: g_count_quantity,
2592: g_count_uom,
2593: l_primary_uom,
2776: AND organization_id = g_cc_entry.organization_id;
2777:
2778: -- Convert the system quantity into the count uom
2779: /*2977228l_system_quantity :=
2780: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2781: 6,
2782: l_system_quantity,
2783: l_primary_uom,
2784: g_count_uom,
2786: NULL
2787: );*/
2788: -- Convert the count quantity into the item primary uom quantity
2789: l_primary_uom_quantity :=
2790: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2791: 6,
2792: g_count_quantity,
2793: g_count_uom,
2794: l_primary_uom,
2907: AND organization_id = g_cc_entry.organization_id;
2908:
2909: -- Convert the system quantity into the count uom
2910: /*2977228l_system_quantity :=
2911: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2912: 6,
2913: l_system_quantity,
2914: l_primary_uom,
2915: g_count_uom,
2917: NULL
2918: );*/
2919: -- Convert the count quantity into the item primary uom quantity
2920: l_primary_uom_quantity :=
2921: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2922: 6,
2923: g_count_quantity,
2924: g_count_uom,
2925: l_primary_uom,
2993: AND organization_id = g_cc_entry.organization_id;
2994:
2995: -- Convert the system quantity into the count uom
2996: /*2977228l_system_quantity :=
2997: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2998: 6,
2999: l_system_quantity,
3000: l_primary_uom,
3001: g_count_uom,
3003: NULL
3004: );*/
3005: -- Convert the count quantity into the item primary uom quantity
3006: l_primary_uom_quantity :=
3007: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
3008: 6,
3009: g_count_quantity,
3010: g_count_uom,
3011: l_primary_uom,
3647: AND organization_id = l_org_id;
3648: END IF;
3649:
3650: l_p_uom_qty :=
3651: inv_convert.inv_um_convert ( l_item_id,
3652: 5,
3653: l_txn_quantity,
3654: l_from_uom,
3655: l_to_uom,
4839: IF (( l_serial_count_option <> 3) OR
4840: ( l_serial_count_option = 3 AND l_serial_number_control_code IN (1, 6) ) )
4841: THEN
4842: l_conversion_qty :=
4843: inv_convert.inv_um_convert ( l_item_id,
4844: 5,
4845: l_primary_sys_qty,
4846: l_from_uom,
4847: l_to_uom,
4910: END IF;
4911:
4912: -- Convert the system quantity into the count uom
4913: /*2977288l_system_qty :=
4914: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
4915: 6,
4916: l_system_qty,
4917: l_to_uom,
4918: g_count_uom,
4922: -- Calculate the adjusted quantity
4923: l_adj_qty := l_count_qty - l_system_qty;
4924: -- Calculate the conversion quantity
4925: l_conversion_qty :=
4926: inv_convert.inv_um_convert ( l_item_id,
4927: 5,
4928: l_adj_qty,
4929: l_from_uom,
4930: l_to_uom,
5825:
5826: -- Convert the system quantity into the primary uom
5827:
5828: l_system_quantity :=
5829: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
5830: 6,
5831: l_system_quantity,
5832: g_count_uom,
5833: l_primary_uom,
6579: FROM mtl_system_items
6580: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
6581:
6582: l_p_uom_qty :=
6583: inv_convert.inv_um_convert ( l_item_id,
6584: 5,
6585: l_txn_quantity,
6586: l_from_uom,
6587: l_to_uom,
9268: END IF;
9269:
9270: l_progress := '30';
9271: l_converted_quantity :=
9272: inv_convert.inv_um_convert ( p_inventory_item_id,
9273: 5,
9274: x_system_quantity,
9275: l_primary_uom,
9276: p_uom_code,