Oracle eBS經驗分享

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;