Which parameter names are supported in Shipping Document sets ? [ID 1079914.1]
SELECT
decode(
lower(decode(l_execution_method_code, 'P', srw_param, 'K', srw_param, end_user_column_name)), --Bugfix 7493868 Modified decode
'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_set_of_books_id', to_char(l_doc_set_params(i).p_set_of_books_id),
'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_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),
'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, end_user_column_name)) parameter_name
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;
留言列表
