| 12345678910111213141516 |
- CREATE VIEW VW_STOCK_COMPOSE AS
- SELECT
- A.GOODS_CD,
- '' AS OPT_CD,
- '' AS OPT_CD1,
- '' AS OPT_CD2,
- SUM(B.CURR_STOCK_QTY)CURR_STOCK_QTY,
- 0 AS BASE_STOCK_QTY,
- 'N' SOLDOUT_YN,
- 0 AS DISP_ORD,
- 'Y' DISP_YN
- FROM TB_GOODS_COMPOSE A
- INNER JOIN VW_STOCK B ON A.COMPS_GOODS_CD = B.GOODS_CD
- AND B.SOLDOUT_YN = 'N'
- WHERE A.USE_YN = 'Y'
- GROUP BY A.GOODS_CD
|
