[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
mdebug(' g_inserted_under_org = '|| g_inserted_under_org );
mdebug(' g_multiple_loc_selected = '|| g_multiple_loc_selected );
/* sql_stmt := ' INSERT into inv_mwb_test_set(
g_id
, g_organization_code
, g_locator_name
, g_item_name
, g_cost_group
, g_project_number
, g_task_number
, g_owning_party
, g_planning_party
, g_lpn_state
, g_status
, g_last_query
, g_organization_id
, g_locator_id
, g_subinventory_code
, g_inventory_item_id
, g_revision
, g_status_id
, g_cost_group_id
, g_lpn_from
, g_lpn_to
, g_lpn_from_id
, g_lpn_to_id
, g_lot_from
, g_lot_to
, g_serial_from
, g_serial_to
, g_workbench_vb
, g_prepacked
, g_project_id
, g_task_id
, g_unit_number
, g_planning_org
, g_owning_org
, g_po_header_id
, g_po_release_id
, g_shipment_header_id_asn
, g_shipment_header_id_interorg
, g_req_header_id
, g_vendor_id
, g_vendor_site_id
, g_source_org_id
, g_chk_inbound
, g_chk_receiving
, g_chk_onhand
, g_include_po_without_asn
, g_expected_from_date
, g_expected_to_date
, g_internal_order_id
, g_vendor_item
, g_grade_from_code
, g_planning_query_mode
, g_owning_qry_mode
, g_wms_enabled_flag
, g_sub_type
, g_rcv_query_mode
, g_detailed
, g_item_description
, g_qty_from
, g_qty_to
, g_locator_control_code
, g_wms_installed_flag
, g_check
, g_responsibility_id
, g_resp_application_id
, g_mln_context_code
, g_msn_context_code
, g_grade_controlled
, g_serial_controlled
, g_lot_controlled
, g_only_locator_status
, g_only_subinventory_status
, g_containerized
, g_locator_controlled
, g_inserted_under_org
, g_revision_controlled
, g_only_lot_status
, g_only_serial_status
, g_view_by
, g_multiple_loc_selected
, g_tree_organization_id
, g_tree_loc_id
, g_tree_item_id
, g_tree_subinventory_code
, g_tree_parent_lpn_id
, g_tree_mat_loc_id
, g_tree_doc_type_id
, g_tree_doc_num
, g_tree_doc_header_id
, g_tree_st_id
, g_tree_rev
, g_tree_cg_id
, g_tree_grade_code
, g_tree_serial_number
, g_tree_lot_number
, g_tree_node_type
, g_tree_node_value
, g_tree_node_state
, g_tree_node_high_value
, g_tree_node_low_value
, g_tree_serial_attr_query
, g_tree_attribute_qf_lot
, g_tree_attribute_qf_serial
, g_tree_query_lot_attr
, g_tree_query_serial_attr
, g_tree_lot_attr_query
, g_tree_event
, g_lot_context
, g_serial_context
, g_is_projects_enabled_org
, g_is_nested_lpn
) VALUES (
inv_mwb_test_set_s.NEXTVAL
:g_organization_code
:g_locator_name
:g_item_name
:g_cost_group
:g_project_number
:g_task_number
:g_owning_party
:g_planning_party
:g_lpn_state
:g_status
:g_last_query
:g_organization_id
:g_locator_id
:g_subinventory_code
:g_inventory_item_id
:g_revision
:g_status_id
:g_cost_group_id
:g_lpn_from
:g_lpn_to
:g_lpn_from_id
:g_lpn_to_id
:g_lot_from
:g_lot_to
:g_serial_from
:g_serial_to
:g_workbench_vb
:g_prepacked
:g_project_id
:g_task_id
:g_unit_number
:g_planning_org
:g_owning_org
:g_po_header_id
:g_po_release_id
:g_shipment_header_id_asn
:g_shipment_header_id_interorg
:g_req_header_id
:g_vendor_id
:g_vendor_site_id
:g_source_org_id
:g_chk_inbound
:g_chk_receiving
:g_chk_onhand
:g_include_po_without_asn
:g_expected_from_date
:g_expected_to_date
:g_internal_order_id
:g_vendor_item
:g_grade_from_code
:g_planning_query_mode
:g_owning_qry_mode
:g_wms_enabled_flag
:g_sub_type
:g_rcv_query_mode
:g_detailed
:g_item_description
:g_qty_from
:g_qty_to
:g_locator_control_code
:g_wms_installed_flag
:g_check
:g_responsibility_id
:g_resp_application_id
:g_mln_context_code
:g_msn_context_code
:g_grade_controlled
:g_serial_controlled
:g_lot_controlled
:g_only_locator_status
:g_only_subinventory_status
:g_containerized
:g_locator_controlled
:g_inserted_under_org
:g_revision_controlled
:g_only_lot_status
:g_only_serial_status
:g_view_by
:g_multiple_loc_selected
:g_tree_organization_id
:g_tree_loc_id
:g_tree_item_id
:g_tree_subinventory_code
:g_tree_parent_lpn_id
:g_tree_mat_loc_id
:g_tree_doc_type_id
:g_tree_doc_num
:g_tree_doc_header_id
:g_tree_st_id
:g_tree_rev
:g_tree_cg_id
:g_tree_grade_code
:g_tree_serial_number
:g_tree_lot_number
:g_tree_node_type
:g_tree_node_value
:g_tree_node_state
:g_tree_node_high_value
:g_tree_node_low_value
:g_tree_serial_attr_query
:g_tree_attribute_qf_lot
:g_tree_attribute_qf_serial
:g_tree_query_lot_attr
:g_tree_query_serial_attr
:g_tree_lot_attr_query
:g_tree_event
:g_lot_context
:g_serial_context
:g_is_projects_enabled_org
:g_is_nested_lpn
) ';
, g_inserted_under_org
, g_revision_controlled
, g_only_lot_status
, g_only_serial_status
, g_view_by
, g_multiple_loc_selected
, g_tree_organization_id
, g_tree_loc_id
, g_tree_item_id
, g_tree_subinventory_code
, g_tree_parent_lpn_id
, g_tree_mat_loc_id
, g_tree_doc_type_id
, g_tree_doc_num
, g_tree_doc_header_id
, g_tree_st_id
, g_tree_rev
, g_tree_cg_id
, g_tree_grade_code
, g_tree_serial_number
, g_tree_lot_number
, g_tree_node_type
, g_tree_node_value
, g_tree_node_state
, g_tree_node_high_value
, g_tree_node_low_value
, g_tree_serial_attr_query
, g_tree_attribute_qf_lot
, g_tree_attribute_qf_serial
, g_tree_query_lot_attr
, g_tree_query_serial_attr
, g_tree_lot_attr_query
, g_tree_event
, g_lot_context
, g_serial_context
, g_is_projects_enabled_org
, g_is_nested_lpn;
/* INSERT INTO inv_mwb_test_set (
g_id ,
g_organization_code ,
g_locator_name ,
g_item_name ,
g_cost_group ,
g_project_number ,
g_task_number ,
g_owning_party ,
g_planning_party ,
g_lpn_state ,
g_status ,
g_last_query ,
g_organization_id ,
g_locator_id ,
g_subinventory_code ,
g_inventory_item_id ,
g_revision ,
g_status_id ,
g_cost_group_id ,
g_lpn_from ,
g_lpn_to ,
g_lpn_from_id ,
g_lpn_to_id ,
g_lot_from ,
g_lot_to ,
g_serial_from ,
g_serial_to ,
g_workbench_vb ,
g_prepacked ,
g_project_id ,
g_task_id ,
g_unit_number ,
g_planning_org ,
g_owning_org ,
g_po_header_id ,
g_po_release_id ,
g_shipment_header_id_asn ,
g_shipment_header_id_interorg ,
g_req_header_id ,
g_vendor_id ,
g_vendor_site_id ,
g_source_org_id ,
g_chk_inbound ,
g_chk_receiving ,
g_chk_onhand ,
g_include_po_without_asn ,
g_expected_from_date ,
g_expected_to_date ,
g_internal_order_id ,
g_vendor_item ,
g_grade_from_code ,
g_planning_query_mode ,
g_owning_qry_mode ,
g_wms_enabled_flag ,
g_sub_type ,
g_rcv_query_mode ,
g_detailed ,
g_item_description ,
g_qty_from ,
g_qty_to ,
g_locator_control_code ,
g_wms_installed_flag ,
g_check ,
g_responsibility_id ,
g_resp_application_id ,
g_mln_context_code ,
g_msn_context_code ,
g_grade_controlled ,
g_serial_controlled ,
g_lot_controlled ,
g_only_locator_status ,
g_only_subinventory_status ,
g_containerized ,
g_locator_controlled ,
g_inserted_under_org ,
g_revision_controlled ,
g_only_lot_status ,
g_only_serial_status ,
g_view_by ,
g_multiple_loc_selected ,
g_tree_organization_id ,
g_tree_loc_id ,
g_tree_item_id ,
g_tree_subinventory_code ,
g_tree_parent_lpn_id ,
g_tree_mat_loc_id ,
g_tree_doc_type_id ,
g_tree_doc_num ,
g_tree_doc_header_id ,
g_tree_st_id ,
g_tree_rev ,
g_tree_cg_id ,
g_tree_grade_code ,
g_tree_serial_number ,
g_tree_lot_number ,
g_tree_node_type ,
g_tree_node_value ,
g_tree_node_state ,
g_tree_node_high_value ,
g_tree_node_low_value ,
g_tree_serial_attr_query ,
g_tree_attribute_qf_lot ,
g_tree_attribute_qf_serial ,
g_tree_query_lot_attr ,
g_tree_query_serial_attr ,
g_tree_lot_attr_query ,
g_tree_event ,
g_lot_context ,
g_serial_context ,
g_is_projects_enabled_org ,
g_is_nested_lpn
)
VALUES (
inv_mwb_test_set_s.nextval ,
g_organization_code ,
g_locator_name ,
g_item_name ,
g_cost_group ,
g_project_number ,
g_task_number ,
g_owning_party ,
g_planning_party ,
g_lpn_state ,
g_status ,
g_last_query ,
g_organization_id ,
g_locator_id ,
g_subinventory_code ,
g_inventory_item_id ,
g_revision ,
g_status_id ,
g_cost_group_id ,
g_lpn_from ,
g_lpn_to ,
g_lpn_from_id ,
g_lpn_to_id ,
g_lot_from ,
g_lot_to ,
g_serial_from ,
g_serial_to ,
g_workbench_vb ,
g_prepacked ,
g_project_id ,
g_task_id ,
g_unit_number ,
g_planning_org ,
g_owning_org ,
g_po_header_id ,
g_po_release_id ,
g_shipment_header_id_asn ,
g_shipment_header_id_interorg ,
g_req_header_id ,
g_vendor_id ,
g_vendor_site_id ,
g_source_org_id ,
g_chk_inbound ,
g_chk_receiving ,
g_chk_onhand ,
g_include_po_without_asn ,
g_expected_from_date ,
g_expected_to_date ,
g_internal_order_id ,
g_vendor_item ,
g_grade_from_code ,
g_planning_query_mode ,
g_owning_qry_mode ,
g_wms_enabled_flag ,
g_sub_type ,
g_rcv_query_mode ,
g_detailed ,
g_item_description ,
g_qty_from ,
g_qty_to ,
g_locator_control_code ,
g_wms_installed_flag ,
g_check ,
g_responsibility_id ,
g_resp_application_id ,
g_mln_context_code ,
g_msn_context_code ,
g_grade_controlled ,
g_serial_controlled ,
g_lot_controlled ,
g_only_locator_status ,
g_only_subinventory_status ,
g_containerized ,
g_locator_controlled ,
g_inserted_under_org ,
g_revision_controlled ,
g_only_lot_status ,
g_only_serial_status ,
g_view_by ,
g_multiple_loc_selected ,
g_tree_organization_id ,
g_tree_loc_id ,
g_tree_item_id ,
g_tree_subinventory_code ,
g_tree_parent_lpn_id ,
g_tree_mat_loc_id ,
g_tree_doc_type_id ,
g_tree_doc_num ,
g_tree_doc_header_id ,
g_tree_st_id ,
g_tree_rev ,
g_tree_cg_id ,
g_tree_grade_code ,
g_tree_serial_number ,
g_tree_lot_number ,
g_tree_node_type ,
g_tree_node_value ,
g_tree_node_state ,
g_tree_node_high_value ,
g_tree_node_low_value ,
g_tree_serial_attr_query ,
g_tree_attribute_qf_lot ,
g_tree_attribute_qf_serial ,
g_tree_query_lot_attr ,
g_tree_query_serial_attr ,
g_tree_lot_attr_query ,
g_tree_event ,
g_lot_context ,
g_serial_context ,
g_is_projects_enabled_org ,
g_is_nested_lpn
);