eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SCHEDULE_UTIL dependencies on DUAL

Line 114: from dual;

110: BEGIN
111:
112: SELECT mrp_atp_schedule_temp_s.nextval
113: INTO MRP_SESSION_ID
114: from dual;
115:
116: return MRP_SESSION_ID;
117: EXCEPTION
118: WHEN OTHERS THEN

Line 5055: -- to give out individual messages for each line. We will store

5051: /* ELSIF p_atp_rec.Ship_Set_Name(J) is not null OR
5052: p_atp_rec.Arrival_Set_Name(J) is not null THEN
5053:
5054: -- This line belongs to a scheduling group. We do not want
5055: -- to give out individual messages for each line. We will store
5056: -- them in atp_tbl which can be displayed by the user.
5057: null;
5058: */
5059: ELSIF p_partial_set THEN

Line 7624: -- Only invoke the conversion for dual tracked items

7620: -- Combining values from these different conversion rates may not give the correct result.
7621: -- Better to compute the secondary to reserve by converting l_qty_to_reserve
7622: IF p_x_line_rec.ordered_quantity_uom2 is not null and
7623: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
7624: -- Only invoke the conversion for dual tracked items
7625: --Bug#8501046,Checked the scenario using default and non-default both types for lot-specific conversion as well and the formula works fine.
7626: l_qty2_to_reserve := nvl(p_x_line_rec.ordered_quantity2, 0)- nvl(l_old_reserved_quantity2,0); --bug 7675494
7627: /*IF l_debug_level > 0 THEN
7628: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;

Line 7628: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;

7624: -- Only invoke the conversion for dual tracked items
7625: --Bug#8501046,Checked the scenario using default and non-default both types for lot-specific conversion as well and the formula works fine.
7626: l_qty2_to_reserve := nvl(p_x_line_rec.ordered_quantity2, 0)- nvl(l_old_reserved_quantity2,0); --bug 7675494
7627: /*IF l_debug_level > 0 THEN
7628: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
7629: END IF;
7630: l_qty2_to_reserve := inv_convert.inv_um_convert(
7631: item_id => p_x_line_rec.inventory_item_id
7632: , lot_number => NULL

Line 8810: -- Only invoke the conversion for dual tracked items

8806: -- Combining values from these different conversion rates may not give the correct result.
8807: -- Better to compute the secondary to reserve by converting l_qty_to_reserve
8808: IF p_x_line_rec.ordered_quantity_uom2 is not null and
8809: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
8810: -- Only invoke the conversion for dual tracked items
8811: IF l_debug_level > 0 THEN
8812: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
8813: END IF;
8814: IF Nvl(p_x_line_rec.fulfillment_base ,'P') ='P' THEN --added for bug 16782621

Line 8812: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;

8808: IF p_x_line_rec.ordered_quantity_uom2 is not null and
8809: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
8810: -- Only invoke the conversion for dual tracked items
8811: IF l_debug_level > 0 THEN
8812: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
8813: END IF;
8814: IF Nvl(p_x_line_rec.fulfillment_base ,'P') ='P' THEN --added for bug 16782621
8815: l_qty2_to_reserve := inv_convert.inv_um_convert(
8816: item_id => p_x_line_rec.inventory_item_id