2022/02/25 08:28:50******************************************【debug start!!】***********************************************
null
2022/02/25 08:28:50******************************************【sql】***********************************************
SELECT * FROM (
                SELECT
                    zaiko_meisai_id,
                    hacchu_no,
                    20220225 as nyukabi,
                    (container_nyuuka_suryo - zaiko_hikiate_zumi_suryo) as hikiate_kano_suryo -- 在庫引当可能数量
                FROM
                    d_zaiko_meisai
                WHERE
                    sh_code = '10FS440002001'
                    AND zaiko_hikiate_flg = 0
                UNION ALL
                SELECT
                    zaiko_meisai_id,
                    hacchu_no,
                    nyuka_yoteibi as nyukabi,
                    (nyuka_yotei_suryo - hikiate_zumi_suryo) as hikiate_kano_suryo -- 入荷引当可能数量
                FROM
                    d_zaiko_meisai
                WHERE
                    sh_code = '10FS440002001'
                    AND nyuka_yotei_hikiate_flg = 0
                    ) a
                ORDER BY nyukabi
                
2022/02/25 08:28:50******************************************【nyukabi】***********************************************
0
2022/02/25 08:28:50******************************************【sql】***********************************************
SELECT * FROM (
                SELECT
                    zaiko_meisai_id,
                    hacchu_no,
                    20220225 as nyukabi,
                    (container_nyuuka_suryo - zaiko_hikiate_zumi_suryo) as hikiate_kano_suryo -- 在庫引当可能数量
                FROM
                    d_zaiko_meisai
                WHERE
                    sh_code = '10FS440001001'
                    AND zaiko_hikiate_flg = 0
                UNION ALL
                SELECT
                    zaiko_meisai_id,
                    hacchu_no,
                    nyuka_yoteibi as nyukabi,
                    (nyuka_yotei_suryo - hikiate_zumi_suryo) as hikiate_kano_suryo -- 入荷引当可能数量
                FROM
                    d_zaiko_meisai
                WHERE
                    sh_code = '10FS440001001'
                    AND nyuka_yotei_hikiate_flg = 0
                    ) a
                ORDER BY nyukabi
                
2022/02/25 08:28:50******************************************【nyukabi】***********************************************
0
2022/02/25 08:28:50******************************************【sql】***********************************************
SELECT * FROM (
                SELECT
                    zaiko_meisai_id,
                    hacchu_no,
                    20220225 as nyukabi,
                    (container_nyuuka_suryo - zaiko_hikiate_zumi_suryo) as hikiate_kano_suryo -- 在庫引当可能数量
                FROM
                    d_zaiko_meisai
                WHERE
                    sh_code = '11PT440005002'
                    AND zaiko_hikiate_flg = 0
                UNION ALL
                SELECT
                    zaiko_meisai_id,
                    hacchu_no,
                    nyuka_yoteibi as nyukabi,
                    (nyuka_yotei_suryo - hikiate_zumi_suryo) as hikiate_kano_suryo -- 入荷引当可能数量
                FROM
                    d_zaiko_meisai
                WHERE
                    sh_code = '11PT440005002'
                    AND nyuka_yotei_hikiate_flg = 0
                    ) a
                ORDER BY nyukabi
                
2022/02/25 08:28:50******************************************【nyukabi】***********************************************
0