[Home] [Help]
387: AND uom_code = order_quantity_uom;
388:
389: SELECT PRIMARY_UNIT_OF_MEASURE
390: INTO l_pri_unit_of_measure
391: FROM mtl_system_items_b
392: WHERE INVENTORY_ITEM_ID = p_item_id
393: AND organization_id = p_to_organization_id;
394:
395: IF Nvl(l_rma_unit_of_measure,-1) <> Nvl(l_pri_unit_of_measure,-1) THEN
1560:
1561: BEGIN
1562: SELECT GRADE_CONTROL_FLAG
1563: INTO l_grade_controlled_flag
1564: FROM mtl_system_items_b
1565: WHERE INVENTORY_ITEM_ID = p_item_id
1566: AND ORGANIZATION_ID = p_to_organization_id;
1567:
1568: IF g_debug = 1 THEN
1623:
1624: begin
1625: select msi.lot_control_code
1626: into l_from_lot_ctrl
1627: from mtl_system_items msi
1628: where msi.inventory_item_id = p_item_id
1629: and msi.organization_id = p_from_organization_id;
1630: exception
1631: when no_data_found then
2046: FROM MTL_UNITS_OF_MEASURE
2047: WHERE unit_of_measure = p_secondary_unit_of_measure;
2048:
2049: /*Check whether the unit of measure conversion is not fixed in the destination org.
2050: Fetch the SECONDARY_DEFAULT_IND from mtl_system_items_b. */
2051:
2052: SELECT secondary_default_ind
2053: INTO l_secondary_default_ind
2054: FROM mtl_system_items_b
2050: Fetch the SECONDARY_DEFAULT_IND from mtl_system_items_b. */
2051:
2052: SELECT secondary_default_ind
2053: INTO l_secondary_default_ind
2054: FROM mtl_system_items_b
2055: WHERE inventory_item_id =p_item_id
2056: AND organization_id =p_to_organization_id;
2057:
2058: /* The values are D => default
2062: l_progress :='033';
2063:
2064: IF g_debug = 1 THEN
2065: print_debug('uom classes for primary and secondary unit_of_measures
2066: and SECONDARY_DEFAULT_IND from mtl_system_items_b are:'|| l_primary_uom_class ||':'||l_secondary_uom_class ||':'||l_secondary_default_ind ||':'||l_progress, 1);
2067: END IF;
2068:
2069: /* Check whether UOM class are different and the dual uom is not of fixed type. */
2070: IF (l_primary_uom_class <> l_secondary_uom_class) AND (l_secondary_default_ind <>'F') THEN
2956: print_debug('previously received quantity for the Lot is :' || l_lot_recv_qty||':'||l_progress, 1);
2957: END IF;
2958:
2959: --If lot was previously received then take that quantity also into account.
2960: -- fetch Primary unit_of_measure of previously received lot from item master (mtl_system_items_b.)
2961: l_progress := '068';
2962:
2963: BEGIN
2964: SELECT PRIMARY_UNIT_OF_MEASURE
2962:
2963: BEGIN
2964: SELECT PRIMARY_UNIT_OF_MEASURE
2965: INTO l_lot_recv_unit_of_measure
2966: FROM mtl_system_items_b
2967: WHERE INVENTORY_ITEM_ID = p_item_id
2968: AND organization_id = p_to_organization_id;
2969:
2970: EXCEPTION
3275: /* Cursor definition to check whether item is a valid and it's lot, child lot controlled */
3276: CURSOR c_chk_msi_attr IS
3277: SELECT lot_control_code,
3278: child_lot_flag
3279: FROM mtl_system_items
3280: WHERE inventory_item_id = p_inventory_item_id
3281: AND organization_id = p_organization_id;
3282:
3283: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
3287: x_return_status := fnd_api.g_ret_sts_success;
3288:
3289: /******************* START Item validation ********************/
3290:
3291: /* Check item attributes in Mtl_system_items Table */
3292:
3293: OPEN c_chk_msi_attr ;
3294: FETCH c_chk_msi_attr INTO l_chk_msi_attr_rec;
3295: