[Home] [Help]
1315: -- WorkOrder_Rec number;
1316:
1317: /* Reservation Variables */
1318: l_rec_reserve CTO_RESERVE_CONFIG.rec_reserve;
1319: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1320: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1321: l_rsrv_qty number := 0;
1322: l_rsrv_id number;
1323: l_status varchar2(1);
1316:
1317: /* Reservation Variables */
1318: l_rec_reserve CTO_RESERVE_CONFIG.rec_reserve;
1319: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1320: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1321: l_rsrv_qty number := 0;
1322: l_rsrv_id number;
1323: l_status varchar2(1);
1324: l_activity_status varchar2(8);
1368: msi.primary_uom_code,
1369: oel.order_quantity_uom,
1370: null,
1371: null) start_quantity,
1372: inv_reservation_global.g_source_type_wip,
1373: wei.wip_entity_id,
1374: oel.schedule_ship_date,
1375: -- Passing revision info only if revision_qty_control_code
1376: -- is not equal to 1
1483: l_rec_reserve.f_item_id := WorkOrder_Rec.inventory_item_id;
1484: l_rec_reserve.f_order_qty_uom := WorkOrder_Rec.order_quantity_uom;
1485: --l_rec_reserve.f_quantity := WorkOrder_Rec.ordered_quantity;
1486: l_rec_reserve.f_quantity := WorkOrder_Rec.start_quantity;
1487: l_rec_reserve.f_supply_source := inv_reservation_global.g_source_type_wip;
1488: l_rec_reserve.f_supply_header_id := WorkOrder_Rec.wip_entity_id;
1489: l_rec_reserve.f_ship_date := WorkOrder_Rec.schedule_ship_date;
1490: l_rec_reserve.f_source_document_type_id := WorkOrder_Rec.source_document_type_id; -- bugfix 1799874
1491: l_rec_reserve.f_bom_revision := WorkOrder_Rec.bom_revision; -- 2620282 : Passing bom revision info
1761: and mr.organization_id = oel.ship_from_org_id
1762: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
1763: and oel.ship_from_org_id = msi.organization_id
1764: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
1765: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1766: INV_RESERVATION_GLOBAL.g_source_type_oe); --bugfix 1799874
1767:
1768:
1769: -- Cursor to get qty in wip_job_schedule_interface
1762: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
1763: and oel.ship_from_org_id = msi.organization_id
1764: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
1765: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1766: INV_RESERVATION_GLOBAL.g_source_type_oe); --bugfix 1799874
1767:
1768:
1769: -- Cursor to get qty in wip_job_schedule_interface
1770: -- This cursor was modified for bugs 2074290, 2435875, 2455900
1785: cursor flow_supply is
1786: select nvl(sum(planned_quantity - quantity_completed),0) -- 2946071
1787: from wip_flow_schedules
1788: where demand_source_line = to_char(pLineId)
1789: and demand_source_type = inv_reservation_global.g_source_type_oe;
1790:
1791: /* end bugfix 2868148 */
1792:
1793: l_mtl_rsv_qty number := 0;