eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on INV_RESERVATION_GLOBAL

Line 69: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

65: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
66: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
67: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
68: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
69: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
70: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
71: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
72: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
73: l_rsv_tbl GME_COMMON_PVT.reservations_tab;

Line 70: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;

66: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
67: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
68: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
69: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
70: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
71: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
72: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
73: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
74: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;

Line 71: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;

67: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
68: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
69: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
70: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
71: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
72: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
73: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
74: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
75: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

Line 130: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

126:
127: CURSOR cur_inv_reservations (p_line_id IN NUMBER) IS
128: SELECT mr.*
129: FROM mtl_reservations mr
130: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
131: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
132: AND demand_source_line_id = p_line_id
133: ORDER BY mr.reservation_id;
134:

Line 131: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv

127: CURSOR cur_inv_reservations (p_line_id IN NUMBER) IS
128: SELECT mr.*
129: FROM mtl_reservations mr
130: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
131: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
132: AND demand_source_line_id = p_line_id
133: ORDER BY mr.reservation_id;
134:
135: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS

Line 138: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

134:
135: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS
136: SELECT count(1)
137: FROM mtl_reservations mr
138: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
139: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
140: AND demand_source_line_id = p_line_id
141: ORDER BY mr.reservation_id;
142:

Line 139: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip

135: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS
136: SELECT count(1)
137: FROM mtl_reservations mr
138: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
139: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
140: AND demand_source_line_id = p_line_id
141: ORDER BY mr.reservation_id;
142:
143: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS

Line 395: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

391: begin
392: SELECT sum(mr.primary_reservation_quantity),primary_uom_code
393: into l_total_primary_rsv_qty, l_primary_uom_code
394: FROM mtl_reservations mr
395: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
396: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
397: AND demand_source_line_id = l_so_line_rec.line_id
398: GROUP BY mr.primary_uom_code;
399: /* Deduct the reserved quantity from the ordered_quantity

Line 396: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv

392: SELECT sum(mr.primary_reservation_quantity),primary_uom_code
393: into l_total_primary_rsv_qty, l_primary_uom_code
394: FROM mtl_reservations mr
395: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
396: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
397: AND demand_source_line_id = l_so_line_rec.line_id
398: GROUP BY mr.primary_uom_code;
399: /* Deduct the reserved quantity from the ordered_quantity
400: * ========================================================= */

Line 460: , p_demand_source_type_id => inv_reservation_global.g_source_type_oe

456: , p_is_lot_control => l_is_lot_control
457: , p_is_serial_control => l_is_serial_control
458: , p_asset_sub_only => FALSE
459: , p_include_suggestion => TRUE
460: , p_demand_source_type_id => inv_reservation_global.g_source_type_oe
461: , p_demand_source_header_id => l_so_line_rec.header_id
462: , p_demand_source_line_id => l_so_line_rec.line_id
463: , p_demand_source_name => NULL
464: , p_demand_source_delivery => NULL

Line 769: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;

765: l_rsv_rec.reservation_uom_id := NULL;
766: l_rsv_rec.ship_ready_flag := NULL;
767: l_rsv_rec.detailed_quantity := NULL;
768: l_rsv_rec.secondary_detailed_quantity := NULL;
769: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
770: l_rsv_rec.supply_source_header_id := l_out_batch_header_rec.batch_id;
771: l_rsv_rec.supply_source_line_id := l_material_detail_rec.material_detail_id;
772:
773: IF (g_debug <= gme_debug.g_log_statement) THEN