javasrc/発注先から親品目
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
#highlighter(MySQL,number){{
SELECT M1.PAR_ITM_CD,M2.ITM_NM AS PAR_ITM_NM,M1.CHD_ITM_C...
FROM CM_BOM_ALL M1
LEFT OUTER JOIN CM_ITM_ALL M2 ON ( M1.PAR_ITM_CD = M2.ITM...
LEFT OUTER JOIN CM_ITM_ALL M3 ON ( M1.CHD_ITM_CD = M3.ITM...
START WITH M1.CHD_ITM_CD IN (
SELECT DISTINCT T2.ITM_CD
FROM st_po_all T1
LEFT OUTER JOIN st_po_d_all T2 ON (T1.PO_NO = T2....
WHERE 0 = 0
AND T1.SPPL_CD = '636201'
)
CONNECT BY PRIOR M1.PAR_ITM_CD = M1.CHD_ITM_CD AND M1.BOM...
;
}}
終了行:
#highlighter(MySQL,number){{
SELECT M1.PAR_ITM_CD,M2.ITM_NM AS PAR_ITM_NM,M1.CHD_ITM_C...
FROM CM_BOM_ALL M1
LEFT OUTER JOIN CM_ITM_ALL M2 ON ( M1.PAR_ITM_CD = M2.ITM...
LEFT OUTER JOIN CM_ITM_ALL M3 ON ( M1.CHD_ITM_CD = M3.ITM...
START WITH M1.CHD_ITM_CD IN (
SELECT DISTINCT T2.ITM_CD
FROM st_po_all T1
LEFT OUTER JOIN st_po_d_all T2 ON (T1.PO_NO = T2....
WHERE 0 = 0
AND T1.SPPL_CD = '636201'
)
CONNECT BY PRIOR M1.PAR_ITM_CD = M1.CHD_ITM_CD AND M1.BOM...
;
}}
ページ名: