APPS.INV_DEFAULT_TROLIN dependencies on MTL_SYSTEM_ITEMS

Line 593: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV

589: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
590: l_primary_uom_code VARCHAR2(3);
591: l_tmp_secondary_quantity NUMBER := NULL; -- INVCONV
592: l_tmp_quantity NUMBER := NULL;
593: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV
594: l_secondary_default_ind MTL_SYSTEM_ITEMS.secondary_default_ind%TYPE; --INVCONV
595: BEGIN
596: l_return_status := 'S';
597: -- INVCONV - Retrieve secondary uom

Line 594: l_secondary_default_ind MTL_SYSTEM_ITEMS.secondary_default_ind%TYPE; --INVCONV

590: l_primary_uom_code VARCHAR2(3);
591: l_tmp_secondary_quantity NUMBER := NULL; -- INVCONV
592: l_tmp_quantity NUMBER := NULL;
593: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV
594: l_secondary_default_ind MTL_SYSTEM_ITEMS.secondary_default_ind%TYPE; --INVCONV
595: BEGIN
596: l_return_status := 'S';
597: -- INVCONV - Retrieve secondary uom
598: IF p_trolin_rec.uom_code IS NULL or p_trolin_rec.secondary_uom IS NULL THEN

Line 604: FROM mtl_system_items

600: INTO l_primary_uom_code, --made when testing 13591755 p_trolin_rec.uom_code,
601: p_trolin_rec.secondary_uom,
602: l_tracking_quantity_ind,
603: l_secondary_default_ind
604: FROM mtl_system_items
605: WHERE inventory_item_id = p_trolin_rec.inventory_item_id
606: AND organization_id = p_trolin_rec.organization_id;
607: END IF;
608: