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

Line 1971: FROM DUAL;

1967: l_final_option(l_final_option.count).shipping_methodes := l_temp_options(I).shipping_methodes;
1968: l_final_option(l_final_option.count).arrival_date := l_temp_options(I).arrival_date ;
1969: ELSE
1970: SELECT LEAST(min_cost, l_temp_options(I).transfer_cost) INTO min_cost
1971: FROM DUAL;
1972: IF min_cost = l_temp_options(I).transfer_cost THEN
1973: l_final_option.trim(l_final_option.count);
1974: l_final_option.extend;
1975: l_final_option(l_final_option.count).resource_id := l_temp_options(I).resource_id;

Line 1997: FROM DUAL;

1993: IF l_ship_count(I).from_org_id <> l_ship_count(I).to_org_id THEN
1994: --IF I <> l_ship_count.count THEN
1995: l_org_ship_methode.extend;
1996: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
1997: FROM DUAL;
1998: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
1999: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
2000: FROM DUAL;
2001: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(I).from_org_id;

Line 2000: FROM DUAL;

1996: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
1997: FROM DUAL;
1998: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
1999: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
2000: FROM DUAL;
2001: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(I).from_org_id;
2002: l_org_ship_methode(l_org_ship_methode.count).to_org := l_ship_count(I).to_org_id ;
2003: previous_position := current_position+1;
2004: current_position := 1;

Line 2016: FROM DUAL;

2012: END LOOP;
2013: ELSE
2014: l_org_ship_methode.extend;
2015: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
2016: FROM DUAL;
2017: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
2018: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
2019: FROM DUAL;
2020: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(1).from_org_id;

Line 2019: FROM DUAL;

2015: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
2016: FROM DUAL;
2017: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
2018: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
2019: FROM DUAL;
2020: l_org_ship_methode(l_org_ship_methode.count).from_org := l_ship_count(1).from_org_id;
2021: l_org_ship_methode(l_org_ship_methode.count).to_org := l_ship_count(1).to_org_id ;
2022: -- l_org_ship_methode(l_org_ship_methode.count).shipping_methode := l_final_option(1).shipping_methodes;
2023: END IF;

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

2083: l_requirement_header.DESTINATION_ORGANIZATION_ID := l_eligible_resources_list(I).source_org;
2084: l_requirement_header.DESTINATION_SUBINVENTORY := l_eligible_resources_list(I).sub_inventory;
2085:
2086: l_req_line_details_tbl.extend;
2087: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
2088: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
2089: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'RES' ;
2090: l_req_line_details_tbl(l_req_line_details_tbl.count).source_id := l_reservation_id ;
2091: ELSE

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

2104: l_parts_lines(rec_count).reservation_id := l_reservation_id;
2105: l_parts_lines(rec_count).requirement_line_id := l_requirements_line_id;
2106: rec_count := rec_count + 1;
2107: l_req_line_details_tbl.extend;
2108: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
2109: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
2110: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
2111: END IF;
2112: END LOOP;

Line 3147: FROM DUAL;*/

3143:
3144: IF csp_resource_org%rowcount =0 THEN
3145: /*select csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id)
3146: INTO l_resource_name
3147: FROM DUAL;*/
3148: OPEN csp_resource_type_name(p_resources(I).resource_type);
3149: LOOP
3150: FETCH csp_resource_type_name INTO l_resource_type_name;
3151: EXIT WHEN csp_resource_type_name%NOTFOUND;

Line 4235: From Dual;

4231: log('do_atp_check', 'l_mrp_database_link: '||l_mrp_database_link);
4232: If l_mrp_database_link IS NULL Then
4233: Select MRP_ATP_SCHEDULE_TEMP_S.NextVal
4234: Into l_session_id
4235: From Dual;
4236: l_calling_module := 724;
4237: Else
4238: get_session_id(p_database_link => l_mrp_database_link,
4239: x_sesssion_id => l_session_id);

Line 4739: from dual;

4735: px_options(px_options.count).missing_parts := 0;
4736: /* ELSE
4737: select least(round(p_temp_options(I).arrival_date,'MI'),round(g_earliest_delivery_date,'MI'))
4738: INTO g_earliest_delivery_date
4739: from dual;
4740: END IF;*/
4741: END LOOP;
4742: EXCEPTION
4743: WHEN OTHERS THEN

Line 4897: FROM DUAL;

4893: FOR I IN 1..p_eligible_resources.count LOOP
4894: IF p_eligible_resources(I).sub_inventory IS NULL THEN
4895: SELECT GREATEST(greatest_available_date, nvl(p_eligible_resources(I).available_date,sysdate))
4896: INTO greatest_available_date
4897: FROM DUAL;
4898: END IF;
4899: END LOOP;
4900:
4901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

4906:
4907: FOR I IN 1..x_ship_count.count LOOP
4908: loop_min := x_ship_count(I).min_leadtime;
4909: loop_max := x_ship_count(I).max_leadtime;
4910: SELECT GREATEST(min_leadtime,loop_min) INTO min_leadtime FROM DUAL;
4911: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;
4912: END LOOP;
4913:
4914: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

4907: FOR I IN 1..x_ship_count.count LOOP
4908: loop_min := x_ship_count(I).min_leadtime;
4909: loop_max := x_ship_count(I).max_leadtime;
4910: SELECT GREATEST(min_leadtime,loop_min) INTO min_leadtime FROM DUAL;
4911: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;
4912: END LOOP;
4913:
4914: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 5021: FROM DUAL;

5017: IF not l_present THEN
5018: FOR N IN resource_count..(resource_count+first_count-1) LOOP
5019: select LEAST(l_min_cost_for_loop,l_resource_shipping_parameters(N).transfer_cost)
5020: INTO l_min_cost_for_loop
5021: FROM DUAL;
5022: END LOOP;
5023: FOR N IN resource_count..(resource_count+first_count-1) LOOP
5024: IF l_min_cost_for_loop = l_resource_shipping_parameters(N).transfer_cost THEN
5025: l_temp_rec .extend;

Line 5109: FROM DUAL ;

5105: l_temp_final_resource(l_temp_final_resource.count).resource_type :=
5106: l_final_resource(K).resource_type ;
5107: SELECT GREATEST(l_final_resource(K).lead_time,l_temp_rec(L).lead_time)
5108: INTO l_temp_final_resource(l_temp_final_resource.count).lead_time
5109: FROM DUAL ;
5110: l_temp_final_resource(l_temp_final_resource.count).transfer_cost :=
5111: (l_temp_rec(L).transfer_cost * l_temp_rec(L) .quantity) +
5112: l_final_resource(K).transfer_cost;
5113: l_temp_final_resource(l_temp_final_resource.count).shipping_methodes

Line 5146: FROM DUAL;*/

5142: FOR J IN 1..l_final_resource.count LOOP
5143: IF L <> J AND l_final_resource(L).lead_time =l_final_resource(J).lead_time THEN
5144: /* SELECT LEAST(min_cost, l_final_resource(J).transfer_cost)
5145: INTO min_cost
5146: FROM DUAL;*/
5147: if min_cost > l_final_resource(J).transfer_cost then
5148: min_cost := l_final_resource(J).transfer_cost;
5149: l_shipping_methods := l_final_resource(J).shipping_methodes;
5150: end if;

Line 7125: FROM DUAL;

7121: l_final_option(l_final_option.count).shipping_methodes := px_options(I).shipping_methodes;
7122: l_final_option(l_final_option.count).arrival_date := px_options(I).arrival_date ;
7123: ELSE
7124: SELECT LEAST(min_cost, px_options(I).transfer_cost) INTO min_cost
7125: FROM DUAL;
7126: IF min_cost = px_options(I).transfer_cost THEN
7127: l_final_option.trim(l_final_option.count);
7128: l_final_option.extend;
7129: l_final_option(l_final_option.count).resource_id := px_options(I).resource_id;

Line 7151: FROM DUAL;

7147: IF p_ship_count(I).from_org_id <> p_ship_count(I).to_org_id THEN
7148: --IF I <> p_ship_count.count THEN
7149: l_org_ship_methode.extend;
7150: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
7151: FROM DUAL;
7152: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
7153: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
7154: FROM DUAL;
7155: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(I).from_org_id;

Line 7154: FROM DUAL;

7150: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
7151: FROM DUAL;
7152: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
7153: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
7154: FROM DUAL;
7155: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(I).from_org_id;
7156: l_org_ship_methode(l_org_ship_methode.count).to_org := p_ship_count(I).to_org_id ;
7157: previous_position := current_position+1;
7158: current_position := 1;

Line 7170: FROM DUAL;

7166: END LOOP;
7167: ELSE
7168: l_org_ship_methode.extend;
7169: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
7170: FROM DUAL;
7171: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
7172: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
7173: FROM DUAL;
7174: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(1).from_org_id;

Line 7173: FROM DUAL;

7169: SELECT INSTR(l_final_option(1).shipping_methodes,'$',1,l_ship_methode_count ) INTO current_position
7170: FROM DUAL;
7171: SELECT SUBSTR(l_final_option(1).shipping_methodes,previous_position,(current_position-previous_position))
7172: INTO l_org_ship_methode(l_org_ship_methode.count).shipping_methode
7173: FROM DUAL;
7174: l_org_ship_methode(l_org_ship_methode.count).from_org := p_ship_count(1).from_org_id;
7175: l_org_ship_methode(l_org_ship_methode.count).to_org := p_ship_count(1).to_org_id ;
7176: --- l_org_ship_methode(l_org_ship_methode.count).shipping_methode := l_final_option(1).shipping_methodes;
7177: END IF;

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

8020: l_statement varchar2(1000);
8021: l_statement1 varchar2(1000);
8022: BEGIN
8023: BEGIN
8024: l_statement := 'Select MRP_ATP_SCHEDULE_TEMP_S.NextVal From Dual@'
8025: || p_database_link;
8026: EXECUTE IMMEDIATE l_statement
8027: INTO x_sesssion_id;
8028: END;