[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT del.delivery_id,
dlg.delivery_leg_id,
wt.ship_method_code,
del.initial_pickup_location_id,
wt.name
FROM wsh_new_deliveries del,
wsh_delivery_legs dlg,
wsh_trip_stops st,
wsh_trips wt
WHERE del.delivery_id = dlg.delivery_id
AND dlg.pick_up_stop_id = st.stop_id
AND st.trip_id = wt.trip_id
AND del.initial_pickup_location_id = st.stop_location_id
AND del.delivery_id = l_delivery_id;
SELECT ood.set_of_books_id
FROM org_organization_definitions ood,
wsh_new_deliveries del
WHERE ood.organization_id = del.organization_id
AND del.delivery_id = p_delivery_id;
SELECT hoi.org_information1
FROM hr_organization_information hoi,
wsh_new_deliveries wnd
WHERE wnd.delivery_id = p_delivery_id
AND hoi.organization_id = wnd.organization_id
AND hoi.org_information_context = 'Accounting Information';
SELECT initial_pickup_location_id
FROM WSH_NEW_DELIVERIES
WHERE delivery_id = p_delivery_id;
SELECT a.application_id,
a.application_short_name,
f.concurrent_program_id,
f.concurrent_program_name,
f.user_concurrent_program_name,
f.printer_name default_printer_name,
f.output_print_style,
f.save_output_flag,
f.print_flag,
f.execution_method_code ,
nvl( rs.number_of_copies, 0 ) number_of_copies,
f.mls_executable_id,
f.output_file_type,
nvl(rs.template_code,f.template_code) template_code,
f.nls_compliant
FROM fnd_concurrent_programs_vl f,
wsh_report_set_lines rs, fnd_application a
WHERE rs.report_set_id = p_report_set_id
AND rs.concurrent_program_id = f.concurrent_program_id
AND rs.application_id = f.application_id
AND a.application_id = f.application_id
AND f.enabled_flag = 'Y'
ORDER BY rs.program_sequence;
SELECT
decode(
lower(decode(l_execution_method_code, 'P', srw_param, 'K',srw_param, end_user_column_name)),
--Bug 6766880 added l_execution_method_code K
'p_request_id', to_char(l_doc_set_params(i).p_request_id), -- bug 1589045
'p_customer_id', to_char(l_doc_set_params(i).p_customer_id),
'p_item_id', to_char(l_doc_set_params(i).p_item_id),
'p_item_cate_set_id', to_char(l_doc_set_params(i).p_item_cate_set_id),
'p_item_category_id', to_char(l_doc_set_params(i).p_item_category_id),
'p_transaction_type_id', to_char(l_doc_set_params(i).p_transaction_type_id),
'p_header_id_low', to_char(l_doc_set_params(i).p_header_id_low),
'p_header_id_high', to_char(l_doc_set_params(i).p_header_id_high),
'p_salesrep_id', to_char(l_doc_set_params(i).p_salesrep_id),
'p_user_id', to_char(l_doc_set_params(i).p_user_id),
'p_territory_name', l_doc_set_params(i).p_territory_name,
'p_item_display', l_doc_set_params(i).p_item_display,
'p_item_flex_code', l_doc_set_params(i).p_item_flex_code,
'p_organization_id', to_char(l_doc_set_params(i).p_organization_id),
'p_org_id', to_char(l_doc_set_params(i).p_organization_id),
'p_sort_by', to_char(l_doc_set_params(i).p_sort_by),
'p_show_functional_currency', l_doc_set_params(i).p_show_functional_currency,
'p_ledger_id', to_char(l_doc_set_params(i).p_ledger_id), -- LE Uptake
'p_order_date_low', to_char(l_doc_set_params(i).p_order_date_low),
'p_order_date_high', to_char(l_doc_set_params(i).p_order_date_high),
'p_delivery_date_low', to_char(l_doc_set_params(i).p_delivery_date_low),
'p_delivery_date_high', to_char(l_doc_set_params(i).p_delivery_date_high),
'p_freight_code', l_doc_set_params(i).p_freight_code,
'p_delivery_id', to_char(l_doc_set_params(i).p_delivery_id),
'p_delivery_id_high', to_char(l_doc_set_params(i).p_delivery_id_high),
'p_delivery_id_low', to_char(l_doc_set_params(i).p_delivery_id_low),
'p_trip_id', to_char(l_doc_set_params(i).p_trip_id),
'p_trip_id_high', to_char(l_doc_set_params(i).p_trip_id_high),
'p_trip_id_low', to_char(l_doc_set_params(i).p_trip_id_low),
-- 'p_delivery_leg_id', to_char(l_doc_set_params(i).p_delivery_leg_id),
'p_bill_of_lading_number', to_char(l_doc_set_params(i).p_bill_of_lading_number),
'p_trip_stop_id', to_char(l_doc_set_params(i).p_trip_stop_id),
'p_departure_date_low', to_char(l_doc_set_params(i).p_departure_date_low),
'p_departure_date_high', to_char(l_doc_set_params(i).p_departure_date_high),
'p_container_id', to_char(l_doc_set_params(i).p_container_id),
'p_print_cust_item', l_doc_set_params(i).p_print_cust_item,
'p_print_mode', l_doc_set_params(i).p_print_mode,
'p_print_all', l_doc_set_params(i).p_print_all,
'p_sort', l_doc_set_params(i).p_sort,
'p_delivery_date_lo', to_char(l_doc_set_params(i).p_delivery_date_lo),
'p_delivery_date_hi', to_char(l_doc_set_params(i).p_delivery_date_hi),
'p_freight_carrier', l_doc_set_params(i).p_freight_carrier,
'p_quantity_precision', l_doc_set_params(i).p_quantity_precision,
'p_locator_flex_code', l_doc_set_params(i).p_locator_flex_code,
'p_warehouse_id', to_char(l_doc_set_params(i).p_warehouse_id),
'p_pick_slip_num_low', to_char(l_doc_set_params(i).pick_slip_num_l),
'p_pick_slip_num_high', to_char(l_doc_set_params(i).pick_slip_num_h),
'p_order_type_id', to_char(l_doc_set_params(i).p_order_type_id), --Bugfix 3604021
'p_order_num_l', to_char(l_doc_set_params(i).p_order_num_l),
'p_order_num_h', to_char(l_doc_set_params(i).p_order_num_h),
'p_order_num_low', to_char(l_doc_set_params(i).p_order_num_low),
'p_order_num_high', to_char(l_doc_set_params(i).p_order_num_high),
--Bug#1577520
--'p_move_order_low', to_char(l_doc_set_params(i).p_move_order_l),
--'p_move_order_high', to_char(l_doc_set_params(i).p_move_order_h),
'p_move_order_low', l_doc_set_params(i).p_move_order_l,
'p_move_order_high', l_doc_set_params(i).p_move_order_h,
'p_ship_method_code', l_doc_set_params(i).p_ship_method_code,
'p_customer_name', l_doc_set_params(i).p_customer_name,
'p_pick_status', l_doc_set_params(i).p_pick_status,
'p_detail_date_low', to_char(l_doc_set_params(i).p_detail_date_l),
'p_detail_date_high', to_char(l_doc_set_params(i).p_detail_date_h),
'p_exception_name', l_doc_set_params(i).p_exception_name,
'p_logging_entity', l_doc_set_params(i).p_logging_entity,
'p_location_id', to_char(l_doc_set_params(i).p_location_id),
'p_creation_date_from', to_char(l_doc_set_params(i).p_creation_date_from),
'p_creation_date_to', to_char(l_doc_set_params(i).p_creation_date_to),
'p_last_update_date_from', to_char(l_doc_set_params(i).p_last_update_date_from),
'p_last_update_date_to', to_char(l_doc_set_params(i).p_last_update_date_to),
'p_severity', l_doc_set_params(i).p_severity,
'p_status', l_doc_set_params(i).p_status,
'p_text1', l_doc_set_params(i).p_text1,
'p_text2', l_doc_set_params(i).p_text2,
'p_text3', l_doc_set_params(i).p_text3,
'p_text4', l_doc_set_params(i).p_text4,
'p_currency_code', l_doc_set_params(i).p_currency_code,
'p_printer_name', l_doc_set_params(i).p_printer_name,
'UNSUPPORTED')
arg_value,
end_user_column_name,
required_flag,
default_value,
default_type,
flex_value_set_id,
lower(decode(l_execution_method_code, 'P', srw_param,'K',srw_param, end_user_column_name)) parameter_name
--Bug 6766880 added l_execution_method_code K
FROM
fnd_descr_flex_column_usages
WHERE application_id = l_application_id
AND descriptive_flexfield_name = '$SRS$.'||l_concurrent_program_name
AND enabled_flag = 'Y'
ORDER BY
column_seq_num;
SELECT
'select ' || id_column_name ||
' from ' || application_table_name,
additional_where_clause,
' and ' || value_column_name || '=:value' ||
' and ' || enabled_column_name || '=''Y''' ||
' and nvl(' || start_date_column_name || ',sysdate)<=sysdate' ||
' and nvl(' || end_date_column_name || ',sysdate)>=sysdate'
FROM fnd_flex_validation_tables
WHERE flex_value_set_id = p_value_set_id
AND id_column_name IS NOT NULL;
select distinct trip_id from wsh_trip_stops
where stop_id=t_stop_id;
l_select_clause VARCHAR2(250);
SELECT MAX(level_type_id)
FROM wsh_report_printers
WHERE concurrent_program_id = p_concurrent_program_id
AND application_id = p_application_id
AND level_value_id =
Decode(level_type_id,
10001, 0,
10002, fnd_global.resp_appl_id,
10003, fnd_global.resp_id,
10004, fnd_global.user_id)
AND enabled_flag = 'Y';
SELECT Nvl(l_printer_name, 'No Printer')
FROM wsh_report_printers
WHERE concurrent_program_id = p_concurrent_program_id
AND application_id = p_application_id
AND level_type_id = p_printer_level
AND level_value_id =
Decode(p_printer_level,
10001, 0,
10002, fnd_global.resp_appl_id,
10003, fnd_global.resp_id,
10004, fnd_global.user_id)
AND enabled_flag = 'Y';
SELECT organization_id
FROM WSH_NEW_DELIVERIES
WHERE delivery_id = v_del_id;
FETCH c_value_set_cursor INTO l_select_clause, l_where_clause, l_additional_clause;
l_select_clause || ' where 1=1 ' || l_additional_clause
|| ' ' || l_where_clause;
l_nls_lang.delete;
all individual requests are protected against updates */
IF l_debug_on THEN --{
WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);
SELECT count(*)
INTO l_bol_count
FROM wsh_document_instances
WHERE entity_name = 'WSH_DELIVERY_LEGS'
AND entity_id = l_delivery_leg_id
AND status <> 'CANCELLED';
SELECT count(*)
into cnt
from wsh_document_instances
WHERE entity_name = 'WSH_NEW_DELIVERIES'
AND entity_id = l_argument(2)
AND document_type = 'PACK_TYPE';
select lower(iso_language),iso_territory into l_language, l_territory
from fnd_languages
where language_code = l_nls_lang(l_nls_count).lang_code;
select lower(iso_language),iso_territory into l_language, l_territory
from fnd_languages
where language_code = userenv('LANG');
l_nls_lang.delete;
all individual requests are protected against updates */
IF l_debug_on THEN --{
WSH_DEBUG_SV.logmsg(l_module_name, 'Setting option for language : '||l_nls_lang(l_nls_count).nls_language);
select lower(iso_language),iso_territory into l_language, l_territory
from fnd_languages
where language_code = l_nls_lang(l_nls_count).lang_code;
select lower(iso_language),iso_territory into l_language, l_territory
from fnd_languages
where language_code = userenv('LANG');