SELECT * from Out_mo_res WHERE pegged_id= ' 001201271060 '; --5000175080/160_1-mfg0011
SELECT * from V_out_mo;
SELECT * FROM V_out_mo_item_1 out_mo_item
Left join Sap_marc on substr (out_mo_item.loc_id, 0, 4) =sap_marc.werks and OUT_MO_ITEM.ITEM=SAP_MARC.MATNR
WHERE productionordid= ' 5000175080/160_1-mfg0011 ';
SELECT * from Out_mo WHERE productionordid= ' 5000175080/160_1-mfg0011 ';
SELECT * from Out_mo_item WHERE productionordid= ' 5000175080/160_1-mfg0011 ';
SELECT * from Temp_mo_split WHERE combine_mo like ' 5000175080/160% ';
SELECT * from Tb_mo_short WHERE demandorderid like '%5000175080/160_1-mfg% '; --5000175080/160_1-mfg000 5000175360/140_1-mfg001
SELECT * from TEMP_SDPP WHERE demandorderid= ' 5000175080/160_1-mfg001 ';
SELECT * from Temp_mo_item WHERE rootid= ' 5000175080/160_1-mfg001 ';
SELECT * from In_bom_header WHERE product_id= ' 000000102001001625 ';
SELECT * from In_bom_details WHERE bom_id= ' 00367552_2023_01 ' and item_id like ' 105% ';
SELECT DISTINCT
Sp. MO_ID,
Sp. Splitseq,
MIN (
Ms. mo_id | | Ms. SPLITSEQ)
Over (
PARTITION by MO. SO_ID,
MO. SO_LINE_ID,
Ms. SITEID,
Mm. Mixitemmark,
Ms. ITEM_ID,
Ms. LINE_ID,
Ms. Plan_start_date)
Combine_mo
From Temp_mo_scheduling MS,
Temp_mo_split SP,
Temp_mo MO,
Temp_mo_mixmark MM
WHERE SP. mo_id = MS. mo_id
and MO. mo_id = MS. mo_id
and MM. Rootid = MS. mo_id
and SP. Splitseq = MS. Splitseq and Sp.combine_mo like ' 5000175080/160% ';
Min. align set writeback MO Work Order component number error SQL