1: PACKAGE BODY MRP_Flow_Schedule_Util AS
2: /* $Header: MRPUSCNB.pls 120.15 2011/12/02 09:33:20 sisankar ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: MRPUSCNB.pls 120.15 2011/12/02 09:33:20 sisankar ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Flow_Schedule_Util';
7:
8: --
9: -- Local Types
10: --
7766: greatest(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL.SHIP_FROM_ORG_ID,
7767: SL.INVENTORY_ITEM_ID,
7768: SL.ORDER_QUANTITY_UOM,
7769: SL.ORDERED_QUANTITY)
7770: - MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(
7771: SL.SHIP_FROM_ORG_ID,
7772: SL.INVENTORY_ITEM_ID,
7773: SL.LINE_ID,
7774: p_use_open_quantity), 0),
7776: greatest(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL.SHIP_FROM_ORG_ID,
7777: SL.INVENTORY_ITEM_ID,
7778: SL.ORDER_QUANTITY_UOM,
7779: SL.ORDERED_QUANTITY)
7780: - MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(
7781: SL.SHIP_FROM_ORG_ID,
7782: SL.INVENTORY_ITEM_ID,
7783: SL.LINE_ID,
7784: p_use_open_quantity), 0))
8202:
8203: END get_routing_designator;
8204:
8205:
8206: END MRP_Flow_Schedule_Util;