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.CSP_SCH_INT_PVT dependencies on DUAL

Line 516: FROM DUAL;

512: l_final_option(l_final_option.count).shipping_methodes := l_temp_options(I).shipping_methodes;
513: l_final_option(l_final_option.count).arrival_date := l_temp_options(I).arrival_date ;
514: ELSE
515: SELECT LEAST(min_cost, l_temp_options(I).transfer_cost) INTO min_cost
516: FROM DUAL;
517: IF min_cost = l_temp_options(I).transfer_cost THEN
518: l_final_option.trim(l_final_option.count);
519: l_final_option.extend;
520: l_final_option(l_final_option.count).resource_id := l_temp_options(I).resource_id;

Line 542: FROM DUAL;

538: IF l_ship_count(I).from_org_id <> l_ship_count(I).to_org_id THEN
539: --IF I <> l_ship_count.count THEN
540: l_org_ship_methode.extend;
541: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
542: FROM DUAL;
543: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
544: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
545: FROM DUAL;
546: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(I).from_org_id;

Line 545: FROM DUAL;

541: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
542: FROM DUAL;
543: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
544: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
545: FROM DUAL;
546: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(I).from_org_id;
547: l_org_ship_methode(l_org_ship_methode.count).to_org := l_ship_count(I).to_org_id ;
548: previous_position := current_position+1;
549: current_position := 1;

Line 561: FROM DUAL;

557: END LOOP;
558: ELSE
559: l_org_ship_methode.extend;
560: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
561: FROM DUAL;
562: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
563: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
564: FROM DUAL;
565: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(1).from_org_id;

Line 564: FROM DUAL;

560: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
561: FROM DUAL;
562: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
563: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
564: FROM DUAL;
565: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(1).from_org_id;
566: l_org_ship_methode(l_org_ship_methode.count).to_org := l_ship_count(1).to_org_id ;
567: -- l_org_ship_methode(l_org_ship_methode.count).shipping_methode := l_final_option(1).shipping_methodes;
568: END IF;

Line 626: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;

622: , p_data => x_msg_data);
623: return;
624: END IF;
625: l_req_line_details_tbl.extend;
626: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
627: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
628: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'RES' ;
629: l_req_line_details_tbl(l_req_line_details_tbl.count).source_id := l_reservation_id ;
630: ELSE

Line 647: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;

643: l_parts_lines(rec_count).reservation_id := l_reservation_id;
644: l_parts_lines(rec_count).requirement_line_id := l_requirements_line_id;
645: rec_count := rec_count + 1;
646: l_req_line_details_tbl.extend;
647: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
648: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
649: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
650: END IF;
651: END LOOP;

Line 1458: FROM DUAL;*/

1454: END LOOP;
1455: IF csp_resource_org%rowcount =0 THEN
1456: /*select csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id)
1457: INTO l_resource_name
1458: FROM DUAL;*/
1459: OPEN csp_resource_type_name(p_resources(I).resource_type);
1460: LOOP
1461: FETCH csp_resource_type_name INTO l_resource_type_name;
1462: EXIT WHEN csp_resource_type_name%NOTFOUND;

Line 1992: From Dual;

1988: l_mrp_database_link := fnd_profile.value(name => 'MRP_ATP_DATABASE_LINK');
1989: If l_mrp_database_link IS NULL Then
1990: Select MRP_ATP_SCHEDULE_TEMP_S.NextVal
1991: Into l_session_id
1992: From Dual;
1993: l_calling_module := 724;
1994: Else
1995: get_session_id(p_database_link => l_mrp_database_link,
1996: x_sesssion_id => l_session_id);

Line 2407: from dual;

2403: px_options(px_options.count).transfer_cost := p_temp_options(I).transfer_cost;
2404: /* ELSE
2405: select least(round(p_temp_options(I).arrival_date,'MI'),round(g_earliest_delivery_date,'MI'))
2406: INTO g_earliest_delivery_date
2407: from dual;
2408: END IF;*/
2409: END LOOP;
2410: EXCEPTION
2411: WHEN OTHERS THEN

Line 2508: FROM DUAL;

2504: FOR I IN 1..p_eligible_resources.count LOOP
2505: IF p_eligible_resources(I).sub_inventory IS NULL THEN
2506: SELECT GREATEST(greatest_available_date, p_eligible_resources(I).available_date)
2507: INTO greatest_available_date
2508: FROM DUAL;
2509: END IF;
2510: END LOOP;
2511: FOR I IN 1..x_ship_count.count LOOP
2512: loop_min := x_ship_count(I).min_leadtime;

Line 2514: SELECT GREATEST(min_leadtime,loop_min) INTO min_leadtime FROM DUAL;

2510: END LOOP;
2511: FOR I IN 1..x_ship_count.count LOOP
2512: loop_min := x_ship_count(I).min_leadtime;
2513: loop_max := x_ship_count(I).max_leadtime;
2514: SELECT GREATEST(min_leadtime,loop_min) INTO min_leadtime FROM DUAL;
2515: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;
2516: END LOOP;
2517: resource_count := 1 ;
2518: WHILE resource_count <= l_resource_shipping_parameters.count LOOP

Line 2515: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;

2511: FOR I IN 1..x_ship_count.count LOOP
2512: loop_min := x_ship_count(I).min_leadtime;
2513: loop_max := x_ship_count(I).max_leadtime;
2514: SELECT GREATEST(min_leadtime,loop_min) INTO min_leadtime FROM DUAL;
2515: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;
2516: END LOOP;
2517: resource_count := 1 ;
2518: WHILE resource_count <= l_resource_shipping_parameters.count LOOP
2519: first_count := 0;

Line 2611: FROM DUAL;

2607: IF not l_present THEN
2608: FOR N IN resource_count..(resource_count+first_count-1) LOOP
2609: select LEAST(l_min_cost_for_loop,l_resource_shipping_parameters(N).transfer_cost)
2610: INTO l_min_cost_for_loop
2611: FROM DUAL;
2612: END LOOP;
2613: FOR N IN resource_count..(resource_count+first_count-1) LOOP
2614: IF l_min_cost_for_loop = l_resource_shipping_parameters(N).transfer_cost THEN
2615: l_temp_rec .extend;

Line 2678: FROM DUAL ;

2674: l_temp_final_resource(l_temp_final_resource.count).resource_type :=
2675: l_final_resource(K).resource_type ;
2676: SELECT GREATEST(l_final_resource(K).lead_time,l_temp_rec(L).lead_time)
2677: INTO l_temp_final_resource(l_temp_final_resource.count).lead_time
2678: FROM DUAL ;
2679: l_temp_final_resource(l_temp_final_resource.count).transfer_cost :=
2680: (l_temp_rec(L).transfer_cost * l_temp_rec(L) .quantity) +
2681: l_final_resource(K).transfer_cost;
2682: l_temp_final_resource(l_temp_final_resource.count).shipping_methodes

Line 2715: FROM DUAL;*/

2711: FOR J IN 1..l_final_resource.count LOOP
2712: IF L <> J AND l_final_resource(L).lead_time =l_final_resource(J).lead_time THEN
2713: /* SELECT LEAST(min_cost, l_final_resource(J).transfer_cost)
2714: INTO min_cost
2715: FROM DUAL;*/
2716: if min_cost > l_final_resource(J).transfer_cost then
2717: min_cost := l_final_resource(J).transfer_cost;
2718: l_shipping_methods := l_final_resource(J).shipping_methodes;
2719: end if;

Line 4583: FROM DUAL;

4579: l_final_option(l_final_option.count).shipping_methodes := px_options(I).shipping_methodes;
4580: l_final_option(l_final_option.count).arrival_date := px_options(I).arrival_date ;
4581: ELSE
4582: SELECT LEAST(min_cost, px_options(I).transfer_cost) INTO min_cost
4583: FROM DUAL;
4584: IF min_cost = px_options(I).transfer_cost THEN
4585: l_final_option.trim(l_final_option.count);
4586: l_final_option.extend;
4587: l_final_option(l_final_option.count).resource_id := px_options(I).resource_id;

Line 4609: FROM DUAL;

4605: IF p_ship_count(I).from_org_id <> p_ship_count(I).to_org_id THEN
4606: --IF I <> p_ship_count.count THEN
4607: l_org_ship_methode.extend;
4608: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
4609: FROM DUAL;
4610: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
4611: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
4612: FROM DUAL;
4613: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(I).from_org_id;

Line 4612: FROM DUAL;

4608: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
4609: FROM DUAL;
4610: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
4611: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
4612: FROM DUAL;
4613: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(I).from_org_id;
4614: l_org_ship_methode(l_org_ship_methode.count).to_org := p_ship_count(I).to_org_id ;
4615: previous_position := current_position+1;
4616: current_position := 1;

Line 4628: FROM DUAL;

4624: END LOOP;
4625: ELSE
4626: l_org_ship_methode.extend;
4627: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
4628: FROM DUAL;
4629: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
4630: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
4631: FROM DUAL;
4632: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(1).from_org_id;

Line 4631: FROM DUAL;

4627: SELECT INSTR(l_final_option(1).shipping_methodes,'-',1,l_ship_methode_count ) INTO current_position
4628: FROM DUAL;
4629: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
4630: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
4631: FROM DUAL;
4632: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(1).from_org_id;
4633: l_org_ship_methode(l_org_ship_methode.count).to_org := p_ship_count(1).to_org_id ;
4634: --- l_org_ship_methode(l_org_ship_methode.count).shipping_methode := l_final_option(1).shipping_methodes;
4635: END IF;

Line 5482: l_statement := 'Select MRP_ATP_SCHEDULE_TEMP_S.NextVal From Dual@'

5478: l_statement varchar2(1000);
5479: l_statement1 varchar2(1000);
5480: BEGIN
5481: BEGIN
5482: l_statement := 'Select MRP_ATP_SCHEDULE_TEMP_S.NextVal From Dual@'
5483: || p_database_link;
5484: EXECUTE IMMEDIATE l_statement
5485: INTO x_sesssion_id;
5486: END;