DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on INV_DECIMALS_PUB

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

7735: SELECT line_id,
7736: --fix bug#3417588
7737: decode(nvl(p_use_open_quantity, 'N'), 'Y',
7738: decode(SL.SHIPPED_QUANTITY, NULL,
7739: greatest(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL.SHIP_FROM_ORG_ID,
7740: SL.INVENTORY_ITEM_ID,
7741: SL.ORDER_QUANTITY_UOM,
7742: SL.ORDERED_QUANTITY)
7743: - MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(

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

7745: SL.INVENTORY_ITEM_ID,
7746: SL.LINE_ID,
7747: p_use_open_quantity), 0),
7748: 0),
7749: greatest(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL.SHIP_FROM_ORG_ID,
7750: SL.INVENTORY_ITEM_ID,
7751: SL.ORDER_QUANTITY_UOM,
7752: SL.ORDERED_QUANTITY)
7753: - MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(

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

8024: *This would allow the reservation qty to be taken into account
8025: *whenever the order source is inconsistent with the corresponding
8026: *flow schedule.
8027: */
8028: SELECT nvl(sum(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(P_ORG_ID,
8029: P_ITEM_ID,
8030: RESERVATION_UOM_CODE,
8031: RESERVATION_QUANTITY)), 0)
8032: INTO l_reserved_qty