SELECT A.FAC_STL_GRD LABEL , A.FAC_STL_GRD VALUE FROM TBD00_STLGRD A
MINUS
SELECT DISTINCT B.FAC_STL_GRD LABEL , B.FAC_STL_GRD VALUE FROM TBB01_FAC_INGR B
SELECT DISTINCT
T.FAC_STL_GRD
,T.FAC_CODE
FROM TBB01_FAC_INGR T
WHERE T.FAC_STL_GRD LIKE ?||'%'
AND T.FAC_CODE LIKE ?||'%'
ORDER BY T.FAC_STL_GRD
SELECT
a.CHEM_CD
, '' COMP_YN
, b.CHEM_AIM
, b.CHEM_MAX
, b.CHEM_MIN
FROM TBB01_SEQ_INGR A , TBB01_FAC_INGR b
WHERE a.CHEM_CD = b.CHEM_CD(+)
AND A.COMP_YN = 'N'
AND b.FAC_STL_GRD(+) = ? --按隐藏的客户公司代码查询（界面UIB010052的表1中的）
AND FAC_CODE(+) = ?
ORDER BY decode(b.CHEM_AIM||b.CHEM_MAX || b.CHEM_MIN, null, 1, 0), a.DISPLAY_SEQ
SELECT
a.CHEM_CD
, A.COMP_DETAIL
, A.COMP_CAL
, 'Y' COMP_YN
, b.CHEM_AIM
, b.CHEM_MAX
, b.CHEM_MIN
FROM TBB01_SEQ_INGR A , TBB01_FAC_INGR b
WHERE a.CHEM_CD = b.CHEM_CD(+)
AND A.COMP_YN = 'Y'
AND b.FAC_STL_GRD(+) = ?
AND b.FAC_CODE(+) = ?
ORDER BY decode(b.CHEM_AIM||b.CHEM_MAX || b.CHEM_MIN, null, 1, 0), a.DISPLAY_SEQ
SELECT T.FAC_DETAIL
FROM TBB01_FAC_INGR T
WHERE T.FAC_STL_GRD = ?
AND T.FAC_CODE = ?
AND T.CHEM_CD = 'XYZ'
SELECT T.FAC_STL_GRD FROM TBB01_FAC_INGR T WHERE T.FAC_STL_GRD = ? AND T.FAC_CODE = ? AND T.CHEM_CD = ?
INSERT INTO TBB01_FAC_INGR(
FAC_STL_GRD
, FAC_CODE
, CHEM_CD
, COMP_YN
, CHEM_AIM
, CHEM_MIN
, CHEM_MAX
, REG_ID
, REG_DTIME)
VALUES(?,? ,? , ? , ? , ? ,?, ? , TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') )
UPDATE TBB01_FAC_INGR T
SET T.CHEM_AIM = ?
,T.CHEM_MIN = ?
,T.CHEM_MAX = ?
,T.MOD_ID = ?
,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
WHERE T.FAC_STL_GRD = ?
AND T.FAC_CODE = ?
AND T.CHEM_CD = ?
UPDATE TBB01_FAC_INGR T
SET T.FAC_DETAIL = ?
WHERE T.FAC_STL_GRD = ?
AND T.FAC_CODE = ?
DELETE FROM TBB01_FAC_INGR T WHERE T.FAC_STL_GRD = ? AND T.FAC_CODE = ? AND T.CHEM_CD = ?
DELETE FROM TBB01_FAC_INGR T WHERE T.FAC_STL_GRD = ? AND T.FAC_CODE = ?
{call ZL_NORM_MANAGE.COPY_FAC_STLGRD(?,?,?,?,?,?)}
{call NIB015051(?,?,?,?)}
{call ZL_NORM_MANAGE.SAVE_FACS_REMK(?,?,?,?,?)}