OUTLET GODEAN_CONFIG

SELECT * FROM m_report_parameter_config LIMIT 10

SELECT * FROM t_system_config LIMIT 10

SELECT * FROM t_parameter LIMIT 10

SELECT * FROM t_system_config WHERE parameter_id IN (23, 24, 25, 26)

SELECT * FROM t_ou LIMIT 10

BEGIN

    UPDATE t_system_config SET parameter_value = 'CV. BERKAT ABADI' WHERE parameter_id = 23

    UPDATE t_system_config SET parameter_value = 'Jl. Godean Km.7 Sidoarum' WHERE parameter_id = 24

    UPDATE t_system_config SET parameter_value = 'Sleman Yogyakarta' WHERE parameter_id = 25

    UPDATE t_system_config SET parameter_value = 'Sleman Yogyakarta' WHERE parameter_id = 26

END

BEGIN

    UPDATE t_system_config SET parameter_value = 'CV. BERKAT ABADI JAYA' WHERE parameter_id = 23

    SELECT * FROM t_system_config WHERE parameter_id IN (23, 24, 25, 26)

    SELECT * FROM t_ou

    UPDATE t_ou SET ou_code = 'BERKAT ABADI JAYA', ou_name = 'CV. BERKAT ABADI JAYA' WHERE ou_id = 49

END