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.

APPS.INV_MINMAX_PVT dependencies on GME_BATCH_HEADER

Line 1226: , gme_batch_header h

1222: SUM ( NVL((NVL(d.wip_plan_qty, d.plan_qty) - d.actual_qty), 0) *
1223: (original_primary_qty/original_qty))
1224: INTO l_qty
1225: FROM gme_material_details d
1226: , gme_batch_header h
1227: WHERE h.batch_type IN (0,10)
1228: AND h.batch_status IN (1,2)
1229: AND h.batch_id = d.batch_id
1230: AND d.inventory_item_id = p_item_id

Line 2021: , gme_batch_header h

2017: , NVL(NVL(d.wip_plan_qty, d.plan_qty) - d.actual_qty, 0))-
2018: NVL(mtr.primary_reservation_quantity,0))
2019: INTO qty
2020: FROM gme_material_details d
2021: , gme_batch_header h
2022: , mtl_reservations mtr
2023: WHERE h.batch_type IN (0,10)
2024: AND h.batch_status IN (1,2)
2025: AND h.batch_id = d.batch_id

Line 4430: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;

4426: , x_ret_stat OUT NOCOPY VARCHAR2
4427: , x_ret_mesg OUT NOCOPY VARCHAR2) IS
4428:
4429:
4430: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
4431: l_eff_id NUMBER(15);
4432: batch_exc EXCEPTION;
4433: x_message_count NUMBER;
4434: x_message_list VARCHAR2(1000);

Line 4436: x_gme_batch_header gme_batch_header%ROWTYPE;

4432: batch_exc EXCEPTION;
4433: x_message_count NUMBER;
4434: x_message_list VARCHAR2(1000);
4435: return_status VARCHAR2(1000);
4436: x_gme_batch_header gme_batch_header%ROWTYPE;
4437: x_exception_material_tbl gmp_batch_wrapper_pkg.exceptions_tab;
4438:
4439: BEGIN
4440:

Line 4461: l_gme_batch_header.organization_id := p_organization_id;

4457: RAISE batch_exc;
4458: ELSE
4459: fnd_profile.initialize(p_user_id);
4460:
4461: l_gme_batch_header.organization_id := p_organization_id;
4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;
4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */
4465: l_gme_batch_header.update_inventory_ind := 'Y' ;

Line 4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;

4458: ELSE
4459: fnd_profile.initialize(p_user_id);
4460:
4461: l_gme_batch_header.organization_id := p_organization_id;
4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;
4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */
4465: l_gme_batch_header.update_inventory_ind := 'Y' ;
4466: -- l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_eff_id ;

Line 4463: l_gme_batch_header.due_date := p_nb_time;

4459: fnd_profile.initialize(p_user_id);
4460:
4461: l_gme_batch_header.organization_id := p_organization_id;
4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;
4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */
4465: l_gme_batch_header.update_inventory_ind := 'Y' ;
4466: -- l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_eff_id ;
4467:

Line 4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */

4460:
4461: l_gme_batch_header.organization_id := p_organization_id;
4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;
4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */
4465: l_gme_batch_header.update_inventory_ind := 'Y' ;
4466: -- l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_eff_id ;
4467:
4468: IF G_TRACE_ON = 1 THEN

Line 4465: l_gme_batch_header.update_inventory_ind := 'Y' ;

4461: l_gme_batch_header.organization_id := p_organization_id;
4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;
4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */
4465: l_gme_batch_header.update_inventory_ind := 'Y' ;
4466: -- l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_eff_id ;
4467:
4468: IF G_TRACE_ON = 1 THEN
4469: print_debug('Calling the GMP Create_Batch Wrapper API', 're_batch', 9);

Line 4466: -- l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_eff_id ;

4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;
4464: l_gme_batch_header.batch_type := 0; /* 0 for batches, 10 for FPOs */
4465: l_gme_batch_header.update_inventory_ind := 'Y' ;
4466: -- l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_eff_id ;
4467:
4468: IF G_TRACE_ON = 1 THEN
4469: print_debug('Calling the GMP Create_Batch Wrapper API', 're_batch', 9);
4470: END IF;

Line 4481: ,p_batch_header_rec => l_gme_batch_header

4477: ,x_message_count => x_message_count
4478: ,x_message_list => x_message_list
4479: ,x_return_status => return_status
4480: ,p_org_code => NULL
4481: ,p_batch_header_rec => l_gme_batch_header
4482: ,x_batch_header_rec => x_gme_batch_header
4483: ,p_batch_size => p_qty
4484: ,p_batch_size_uom => p_uom
4485: ,p_creation_mode => 'PRODUCT'

Line 4482: ,x_batch_header_rec => x_gme_batch_header

4478: ,x_message_list => x_message_list
4479: ,x_return_status => return_status
4480: ,p_org_code => NULL
4481: ,p_batch_header_rec => l_gme_batch_header
4482: ,x_batch_header_rec => x_gme_batch_header
4483: ,p_batch_size => p_qty
4484: ,p_batch_size_uom => p_uom
4485: ,p_creation_mode => 'PRODUCT'
4486: ,p_recipe_id => NULL

Line 4510: print_debug('Created batch with batch_id '||to_char(x_gme_batch_header.batch_id)

4506: END IF;
4507: RAISE batch_exc;
4508: ELSE
4509: IF G_TRACE_ON = 1 THEN
4510: print_debug('Created batch with batch_id '||to_char(x_gme_batch_header.batch_id)
4511: , 're_batch', 9);
4512: END IF;
4513: END IF;
4514: