谁知道这脚本是什么意思？谁就是大师级别！并且解释一下
select '' item41
, decode(a.shiage_tenkai,'1','disabled','5','disabled','') item37
, decode(decode(b.s_seihin_kb,'s',a.press_tenkai,a.shiage_tenkai),'0','未展開','2','未展開','1','展開済','5','展開済','3','展開','未展開') item42
, b.hinmei item43
, nvl(decode(upper(b.tatene_shiji_tani),'x',b.jutyu_butsuryo , b.juchu_suryo) ,0) item44
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item45
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item47
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item49
, '手動引当' item50
, '' item60
, decode( b.s_seihin_kb, 'm', nvl(hin.seizouhinmei,' '),
nvl(a.shiage_seizouhinmei, siage.shiage_seizouhinmei)
) item61
, decode( b.s_seihin_kb, 'm', nvl(hin.pack_hin ,' '),
nvl(a.shiage_pack_hinmei, siage.shiage_pack_hin)
) item188
, nvl(a.shiage_torisu ,siage.shiage_kite_kom ) item62
, decode( b.s_seihin_kb, 's', nvl(hin.seizouhinmei,' '),
nvl(a.press_seizouhinmei,press.press_seizouhinmei)
) item63
, decode( b.s_seihin_kb, 's', nvl(hin.pack_hin ,' '),
nvl(a.press_pack_hinmei , press.press_pack_hin)
) item189
, nvl( a.press_teijaku_size, press.press_kite_kom ) item64
, nvl(a.shiage_tenkai_hitsuyo , nvl(decode(upper(b.tatene_shiji_tani),'x',b.tehaibutsuryou , b.tehaisuryo) ,0)) item65
, nvl(a.shiage_tenkai_hitsuyo_tani,decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku )) item66
, 'プレス展開' item67
, to_char(a.shiage_tonyu_ymd,'yy/mm/dd') item68
, a.press_hitsuyo item69
, nvl(a.press_hitsuyo_tani ,decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku )) item70
, '仕上展開' item71
, to_char( decode( a.press_ymd, null, b.noki_base_press_ymd,
decode( sign(to_char(a.press_ymd,'hh24mi')-'0800'),-1,a.press_ymd-1,a.press_ymd )
), 'rr/mm/dd' ) item72
, a.press_kai item73
, nvl(a.press_jikan,'08:00') item74
, nvl( a.press_setsubiname , press.press_setsubiname ) item75
, nvl( a.press_teijaku_size, press.press_kite_kom ) item76
, to_char(a.tokou_yokyuu_ymd,'yy/mm/dd hh24:mi') item77
, to_char(a.tokou_press_ymd,'yy/mm/dd') item78
, b.ukeban item79
, b.chumonnushi item80
, decode(nvl(b.noki,''),'','',decode(sign(to_number(substr(b.noki,length(b.noki)-1))-31),1, substr(b.noki,3,2)||'/'||substr(b.noki,5,2)||'/'||substr(b.noki,length(b.noki)-1),to_char(to_date(b.noki,'yyyy/mm/dd'),'yy/mm/dd'))) item81
, to_char(b.uketsuke_ymd,'yy/mm/dd') item82
, '0' item83
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item84
, nvl(0,0) item85
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item86
, nvl(0,0) item87
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item88
, '' item89
, decode(upper(b.tatene_shiji_tani), 'x' , b.butsuryoutaniryaku , b.suryotaniryaku ) item90
