568: and inventory_item_id = 0;
569:
570: --Fix for bug#4888567
571: --UOM conversion from Resource UOM to HOUR UOM was not properly done
572: -- Using the standard function inv_convert.inv_um_convert to convert
573: -- between resource UOM and standard HR uom code received from BOM profile value.
574:
575:
576: -- Fixed bug 5440007
569:
570: --Fix for bug#4888567
571: --UOM conversion from Resource UOM to HOUR UOM was not properly done
572: -- Using the standard function inv_convert.inv_um_convert to convert
573: -- between resource UOM and standard HR uom code received from BOM profile value.
574:
575:
576: -- Fixed bug 5440007
577: -- Added decode clause to derive the quantity from wip_discrete_jobs only if the parameter
751: l_opSchYesTbls op_rectbl_t;
752: l_startOpIdx NUMBER;
753: l_endOpIdx NUMBER;
754:
755: --standard who columns
756: l_sysDate DATE := sysdate;
757: l_userID NUMBER := fnd_global.user_id;
758: l_loginID NUMBER := fnd_global.login_id;
759: l_reqID NUMBER := fnd_global.conc_request_id;