哪位高手帮忙看一下PV_SHEET是什么意思
(:PV_SELECT = 'NORMAL' AND NVL(PNT_CODE, '.') = 'N')
OR (:PV_SELECT = 'REPEAT' AND NVL(PNT_CODE, '.') = 'Y')
SQL原句
SELECT M.ISSU_NO , -- ????
M.ISSU_DATE , -- ????
M.MCH_NO , -- ????
M.PROC_NO , -- ????
M.TOOL_NO , -- ????
M.SC_NO , -- ???
M.PDC_1 , -- ????
M.PDC_2 , -- ??
M.PDC_3 , -- ??
M.PDC_4 , -- ????
M.PDC_5 , -- OPTION
D.REEL_NO ,
D.REEL_QTY ,
T.CST_REFE_NO
FROM PDC_ISSU_M M, PDC_ISSU_D D,CST_ORDE_M T
WHERE M.ISSU_NO = D.ISSU_NO
AND T.SC_NO = M.SC_NO
AND M.ISSU_NO BETWEEN NVL(:PV_ISSU_NO_B, '0') AND RPAD(NVL(:PV_ISSU_NO_E, 'Z'), 9, 'Z')
AND ( (:PV_SELECT = 'NORMAL' AND NVL(PNT_CODE, '.') = 'N')
OR (:PV_SELECT = 'REPEAT' AND NVL(PNT_CODE, '.') = 'Y')
)
ORDER BY M.ISSU_NO, D.REEL_NO
(:PV_SELECT = 'NORMAL' AND NVL(PNT_CODE, '.') = 'N')
OR (:PV_SELECT = 'REPEAT' AND NVL(PNT_CODE, '.') = 'Y')
SQL原句
SELECT M.ISSU_NO , -- ????
M.ISSU_DATE , -- ????
M.MCH_NO , -- ????
M.PROC_NO , -- ????
M.TOOL_NO , -- ????
M.SC_NO , -- ???
M.PDC_1 , -- ????
M.PDC_2 , -- ??
M.PDC_3 , -- ??
M.PDC_4 , -- ????
M.PDC_5 , -- OPTION
D.REEL_NO ,
D.REEL_QTY ,
T.CST_REFE_NO
FROM PDC_ISSU_M M, PDC_ISSU_D D,CST_ORDE_M T
WHERE M.ISSU_NO = D.ISSU_NO
AND T.SC_NO = M.SC_NO
AND M.ISSU_NO BETWEEN NVL(:PV_ISSU_NO_B, '0') AND RPAD(NVL(:PV_ISSU_NO_E, 'Z'), 9, 'Z')
AND ( (:PV_SELECT = 'NORMAL' AND NVL(PNT_CODE, '.') = 'N')
OR (:PV_SELECT = 'REPEAT' AND NVL(PNT_CODE, '.') = 'Y')
)
ORDER BY M.ISSU_NO, D.REEL_NO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货