[Home] [Help]
1411: AND organization_id = g_cc_entry.organization_id;
1412:
1413: -- Convert the count quantity into the item primary uom quantity
1414: l_primary_uom_quantity :=
1415: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1416: 6,
1417: g_count_quantity,
1418: g_count_uom,
1419: l_primary_uom,
1667: AND organization_id = g_cc_entry.organization_id;
1668:
1669: -- Convert the system quantity into the count uom
1670: /*2977228l_system_quantity :=
1671: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
1672: 6,
1673: l_system_quantity,
1674: l_primary_uom,
1675: g_count_uom,
2139: AND organization_id = g_cc_entry.organization_id;
2140:
2141: -- Convert the system quantity into the count uom
2142: /*2977228l_system_quantity :=
2143: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2144: 6,
2145: l_system_quantity,
2146: l_primary_uom,
2147: g_count_uom,
2149: NULL
2150: );*/
2151: -- Convert the count quantity into the item primary uom quantity
2152: l_primary_uom_quantity :=
2153: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2154: 6,
2155: g_count_quantity,
2156: g_count_uom,
2157: l_primary_uom,
2231: AND organization_id = g_cc_entry.organization_id;
2232:
2233: -- Convert the system quantity into the count uom
2234: /*2977228l_system_quantity :=
2235: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2236: 6,
2237: l_system_quantity,
2238: l_primary_uom,
2239: g_count_uom,
2241: NULL
2242: );*/
2243: -- Convert the count quantity into the item primary uom quantity
2244: l_primary_uom_quantity :=
2245: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2246: 6,
2247: g_count_quantity,
2248: g_count_uom,
2249: l_primary_uom,
2328: AND organization_id = g_cc_entry.organization_id;
2329:
2330: -- Convert the system quantity into the count uom
2331: /*2977228l_system_quantity :=
2332: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2333: 6,
2334: l_system_quantity,
2335: l_primary_uom,
2336: g_count_uom,
2338: NULL
2339: );*/
2340: -- Convert the count quantity into the item primary uom quantity
2341: l_primary_uom_quantity :=
2342: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2343: 6,
2344: g_count_quantity,
2345: g_count_uom,
2346: l_primary_uom,
2529: AND organization_id = g_cc_entry.organization_id;
2530:
2531: -- Convert the system quantity into the count uom
2532: /*2977228l_system_quantity :=
2533: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2534: 6,
2535: l_system_quantity,
2536: l_primary_uom,
2537: g_count_uom,
2539: NULL
2540: );*/
2541: -- Convert the count quantity into the item primary uom quantity
2542: l_primary_uom_quantity :=
2543: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2544: 6,
2545: g_count_quantity,
2546: g_count_uom,
2547: l_primary_uom,
2660: AND organization_id = g_cc_entry.organization_id;
2661:
2662: -- Convert the system quantity into the count uom
2663: /*2977228l_system_quantity :=
2664: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2665: 6,
2666: l_system_quantity,
2667: l_primary_uom,
2668: g_count_uom,
2670: NULL
2671: );*/
2672: -- Convert the count quantity into the item primary uom quantity
2673: l_primary_uom_quantity :=
2674: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2675: 6,
2676: g_count_quantity,
2677: g_count_uom,
2678: l_primary_uom,
2746: AND organization_id = g_cc_entry.organization_id;
2747:
2748: -- Convert the system quantity into the count uom
2749: /*2977228l_system_quantity :=
2750: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2751: 6,
2752: l_system_quantity,
2753: l_primary_uom,
2754: g_count_uom,
2756: NULL
2757: );*/
2758: -- Convert the count quantity into the item primary uom quantity
2759: l_primary_uom_quantity :=
2760: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
2761: 6,
2762: g_count_quantity,
2763: g_count_uom,
2764: l_primary_uom,
3350: AND organization_id = l_org_id;
3351: END IF;
3352:
3353: l_p_uom_qty :=
3354: inv_convert.inv_um_convert ( l_item_id,
3355: 5,
3356: l_txn_quantity,
3357: l_from_uom,
3358: l_to_uom,
4496: IF (( l_serial_count_option <> 3) OR
4497: ( l_serial_count_option = 3 AND l_serial_number_control_code IN (1, 6) ) )
4498: THEN
4499: l_conversion_qty :=
4500: inv_convert.inv_um_convert ( l_item_id,
4501: 5,
4502: l_primary_sys_qty,
4503: l_from_uom,
4504: l_to_uom,
4837: IF (( l_serial_count_option <> 3) OR
4838: ( l_serial_count_option = 3 AND l_serial_number_control_code IN (1, 6) ) )
4839: THEN
4840: l_conversion_qty :=
4841: inv_convert.inv_um_convert ( l_item_id,
4842: 5,
4843: l_primary_sys_qty,
4844: l_from_uom,
4845: l_to_uom,
4900: AND organization_id = g_cc_entry.organization_id;
4901:
4902: -- Convert the system quantity into the count uom
4903: /*2977288l_system_qty :=
4904: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
4905: 6,
4906: l_system_qty,
4907: l_to_uom,
4908: g_count_uom,
4912: -- Calculate the adjusted quantity
4913: l_adj_qty := l_count_qty - l_system_qty;
4914: -- Calculate the conversion quantity
4915: l_conversion_qty :=
4916: inv_convert.inv_um_convert ( l_item_id,
4917: 5,
4918: l_adj_qty,
4919: l_from_uom,
4920: l_to_uom,
5719:
5720: -- Convert the system quantity into the primary uom
5721:
5722: l_system_quantity :=
5723: inv_convert.inv_um_convert ( g_cc_entry.inventory_item_id,
5724: 6,
5725: l_system_quantity,
5726: g_count_uom,
5727: l_primary_uom,
6473: FROM mtl_system_items
6474: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
6475:
6476: l_p_uom_qty :=
6477: inv_convert.inv_um_convert ( l_item_id,
6478: 5,
6479: l_txn_quantity,
6480: l_from_uom,
6481: l_to_uom,
9023: END IF;
9024:
9025: l_progress := '30';
9026: l_converted_quantity :=
9027: inv_convert.inv_um_convert ( p_inventory_item_id,
9028: 5,
9029: x_system_quantity,
9030: l_primary_uom,
9031: p_uom_code,