DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on INV_DECIMALS_PUB

Line 7766: greatest(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL.SHIP_FROM_ORG_ID,

7762: SELECT line_id,
7763: --fix bug#3417588
7764: decode(nvl(p_use_open_quantity, 'N'), 'Y',
7765: decode(SL.SHIPPED_QUANTITY, NULL,
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(

Line 7776: greatest(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL.SHIP_FROM_ORG_ID,

7772: SL.INVENTORY_ITEM_ID,
7773: SL.LINE_ID,
7774: p_use_open_quantity), 0),
7775: 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(

Line 8055: SELECT nvl(sum(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(P_ORG_ID,

8051: *This would allow the reservation qty to be taken into account
8052: *whenever the order source is inconsistent with the corresponding
8053: *flow schedule.
8054: */
8055: SELECT nvl(sum(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(P_ORG_ID,
8056: P_ITEM_ID,
8057: RESERVATION_UOM_CODE,
8058: RESERVATION_QUANTITY)), 0)
8059: INTO l_reserved_qty