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 89: from dual;

85: BEGIN
86:
87: SELECT mrp_atp_schedule_temp_s.nextval
88: INTO MRP_SESSION_ID
89: from dual;
90:
91: return MRP_SESSION_ID;
92: EXCEPTION
93: WHEN OTHERS THEN

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

4068: /* ELSIF p_atp_rec.Ship_Set_Name(J) is not null OR
4069: p_atp_rec.Arrival_Set_Name(J) is not null THEN
4070:
4071: -- This line belongs to a scheduling group. We do not want
4072: -- to give out individual messages for each line. We will store
4073: -- them in atp_tbl which can be displayed by the user.
4074: null;
4075: */
4076: ELSIF p_partial_set THEN

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

6347: -- Combining values from these different conversion rates may not give the correct result.
6348: -- Better to compute the secondary to reserve by converting l_qty_to_reserve
6349: IF p_x_line_rec.ordered_quantity_uom2 is not null and
6350: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
6351: -- Only invoke the conversion for dual tracked items
6352: IF l_debug_level > 0 THEN
6353: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
6354: END IF;
6355: l_qty2_to_reserve := inv_convert.inv_um_convert(

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

6349: IF p_x_line_rec.ordered_quantity_uom2 is not null and
6350: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
6351: -- Only invoke the conversion for dual tracked items
6352: IF l_debug_level > 0 THEN
6353: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
6354: END IF;
6355: l_qty2_to_reserve := inv_convert.inv_um_convert(
6356: item_id => p_x_line_rec.inventory_item_id
6357: , lot_number => NULL

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

7510: -- Combining values from these different conversion rates may not give the correct result.
7511: -- Better to compute the secondary to reserve by converting l_qty_to_reserve
7512: IF p_x_line_rec.ordered_quantity_uom2 is not null and
7513: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
7514: -- Only invoke the conversion for dual tracked items
7515: IF l_debug_level > 0 THEN
7516: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
7517: END IF;
7518: l_qty2_to_reserve := inv_convert.inv_um_convert(

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

7512: IF p_x_line_rec.ordered_quantity_uom2 is not null and
7513: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR THEN
7514: -- Only invoke the conversion for dual tracked items
7515: IF l_debug_level > 0 THEN
7516: oe_debug_pub.add( 'DUAL Tracked quantity so convert the qty to reserve ' || l_qty_to_reserve , 1 ) ;
7517: END IF;
7518: l_qty2_to_reserve := inv_convert.inv_um_convert(
7519: item_id => p_x_line_rec.inventory_item_id
7520: , lot_number => NULL