INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral', 'Produção Geral', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral') IS NULL LIMIT 1);

INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_ajax', 'Produção Geral - Ajax', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_ajax') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_controle', 'Produção Geral - Controle', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_controle') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_controle_ajax', 'Produção Geral - Controle Ajax', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_controle_ajax') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'frm_prd_ordem_producao_impressao', 'Produção Geral - Impressao', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_ordem_producao_impressao') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'cns_prd_producao_geral_historico', 'Produção Geral - Historico', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'cns_prd_producao_geral_historico') IS NULL LIMIT 1);

INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_data_prev', 'Produção Geral - Data Previsão', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_data_prev') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_pelo_plano', 'Produção Geral - Pĺano de Fabricacao', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_pelo_plano') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_pelo_plano_ajax', 'Produção Geral - Pĺano de Fabricacao Ajax', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_pelo_plano_ajax') IS NULL LIMIT 1);


INSERT INTO ctl_aplicativo (SELECT 'frm_prd_producao_geral_pelo_plano_gerar', 'Produção Geral - Gerar Ordem', 'PRD', 'C' FROM ctl_aplicativo WHERE aplinome = 'frm_bas_filial'
AND (SELECT aplinome FROM ctl_aplicativo WHERE aplinome = 'frm_prd_producao_geral_pelo_plano_gerar') IS NULL LIMIT 1);







--#######################################################################################
--#######################################################################################
--#######################################################################################
--#######################################################################################
--#######################################################################################




INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'cns_prd_producao_geral_historico', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'cns_prd_producao_geral_historico')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_ordem_producao_impressao', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_ordem_producao_impressao')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_ajax', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_ajax')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_controle', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_controle')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_controle_ajax', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_controle_ajax')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_data_prev', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_data_prev')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_pelo_plano', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_pelo_plano')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_pelo_plano_ajax', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_pelo_plano_ajax')
GROUP BY grupousucod);

INSERT INTO ctl_grupo_x_direito  (
SELECT grupousucod, 'frm_prd_producao_geral_pelo_plano_gerar', 'T'
  FROM ctl_grupo_x_direito
 WHERE grupousucod = 1
   AND grupousucod NOT IN (SELECT grupousucod FROM ctl_grupo_x_direito  WHERE aplinome = 'frm_prd_producao_geral_pelo_plano_gerar')
GROUP BY grupousucod);

--#######################################################################################
--#######################################################################################
--#######################################################################################
--#######################################################################################
--#######################################################################################


DELETE FROM ctl_menu_nivel WHERE codigo IN (6103);
INSERT INTO ctl_menu_nivel VALUES (6103, '05) Ordem de Produção (Geral)', 9999, '', '_self', 'frm_prd_producao_geral', 2522, 1);


--#######################################################################################
--#######################################################################################
--#######################################################################################
--#######################################################################################
--#######################################################################################



DELETE FROM ctl_menu_nivel_dependencia WHERE aplicacao = 'frm_prd_producao_geral'; 
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'cns_prd_producao_geral_historico');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_ordem_producao_impressao');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_ajax');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_controle');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_controle_ajax');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_data_prev');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_pelo_plano');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_pelo_plano_ajax');
INSERT INTO ctl_menu_nivel_dependencia VALUES('frm_prd_producao_geral', 'frm_prd_producao_geral_pelo_plano_gerar');