APPS.INV_DEFAULT_TROLIN dependencies on MTL_SYSTEM_ITEMS

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

560: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
561: l_primary_uom_code VARCHAR2(3);
562: l_tmp_secondary_quantity NUMBER := NULL; -- INVCONV
563: l_tmp_quantity NUMBER := NULL;
564: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV
565: l_secondary_default_ind MTL_SYSTEM_ITEMS.secondary_default_ind%TYPE; --INVCONV
566: BEGIN
567: l_return_status := 'S';
568: -- INVCONV - Retrieve secondary uom

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

561: l_primary_uom_code VARCHAR2(3);
562: l_tmp_secondary_quantity NUMBER := NULL; -- INVCONV
563: l_tmp_quantity NUMBER := NULL;
564: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV
565: l_secondary_default_ind MTL_SYSTEM_ITEMS.secondary_default_ind%TYPE; --INVCONV
566: BEGIN
567: l_return_status := 'S';
568: -- INVCONV - Retrieve secondary uom
569: IF p_trolin_rec.uom_code IS NULL or p_trolin_rec.secondary_uom IS NULL THEN

Line 575: FROM mtl_system_items

571: INTO p_trolin_rec.uom_code,
572: p_trolin_rec.secondary_uom,
573: l_tracking_quantity_ind,
574: l_secondary_default_ind
575: FROM mtl_system_items
576: WHERE inventory_item_id = p_trolin_rec.inventory_item_id
577: AND organization_id = p_trolin_rec.organization_id;
578: END IF;
579: