DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on MRP_FLOW_SCHEDULE_UTIL

Line 663: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(SL1.LINE_ID,

659: GREATEST((INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL1.SHIP_FROM_ORG_ID,
660: SL1.INVENTORY_ITEM_ID,
661: SL1.ORDER_QUANTITY_UOM,
662: SL1.ORDERED_QUANTITY) -
663: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(SL1.LINE_ID,
664: 2,
665: TO_CHAR(NULL),
666: MSI1.REPLENISH_TO_ORDER_FLAG) -
667: MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(SL1.SHIP_FROM_ORG_ID,

Line 667: MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(SL1.SHIP_FROM_ORG_ID,

663: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(SL1.LINE_ID,
664: 2,
665: TO_CHAR(NULL),
666: MSI1.REPLENISH_TO_ORDER_FLAG) -
667: MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(SL1.SHIP_FROM_ORG_ID,
668: SL1.INVENTORY_ITEM_ID,
669: SL1.LINE_ID,
670: MSI1.REPLENISH_TO_ORDER_FLAG)),
671: 0) order_quantity,

Line 690: mrp_flow_schedule_util.check_holds(sl2.header_id,

686: null,
687: 0,
688: decode(sl2.ato_line_id,
689: null,
690: mrp_flow_schedule_util.check_holds(sl2.header_id,
691: sl2.line_id,
692: 'OEOL',
693: 'LINE_SCHEDULING'),
694: mrp_flow_schedule_util.check_holds(sl2.header_id,

Line 694: mrp_flow_schedule_util.check_holds(sl2.header_id,

690: mrp_flow_schedule_util.check_holds(sl2.header_id,
691: sl2.line_id,
692: 'OEOL',
693: 'LINE_SCHEDULING'),
694: mrp_flow_schedule_util.check_holds(sl2.header_id,
695: sl2.line_id,
696: null,
697: null))) hold
698: from oe_order_lines_all sl2) line_holds,

Line 747: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(TO_CHAR(MR1.TRANSACTION_ID),

743: MR1.INVENTORY_ITEM_ID,
744: WL.LINE_ID,
745: NVL(MR1.FIRM_DATE, MR1.NEW_SCHEDULE_DATE) order_date,
746: GREATEST((NVL(MR1.FIRM_QUANTITY, MR1.NEW_ORDER_QUANTITY) -
747: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(TO_CHAR(MR1.TRANSACTION_ID),
748: 100,
749: NULL,
750: NULL)),
751: 0) order_quantity