16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3059' AND Sc_No='9125' AND Seq_No='11' AND Item_Code='SP-C208' AND Shortage_Qty='5' AND PO_No='IF-4832'
42
43
44
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3079' AND Sc_No='9213' AND Seq_No='7' AND Item_Code='MTS-307-2' AND Shortage_Qty='6' AND PO_No='IF-4874'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3083' AND Sc_No='9205' AND Seq_No='16' AND Item_Code='TDS-C302-8FOV' AND Shortage_Qty='1' AND PO_No='IF-4869'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3090' AND Sc_No='9234' AND Seq_No='4' AND Item_Code='MTB-153' AND Shortage_Qty='1' AND PO_No='IF-4886'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3093' AND Sc_No='9246' AND Seq_No='1' AND Item_Code='MTS-291-5' AND Shortage_Qty='1' AND PO_No='IF-4897'
46
50
52
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3108' AND Sc_No='9286' AND Seq_No='1' AND Item_Code='B107N' AND Shortage_Qty='2' AND PO_No='IF-4921'
53
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3136' AND Sc_No='9339' AND Seq_No='3' AND Item_Code='SP-C208-V' AND Shortage_Qty='1' AND PO_No='IF-4955'
54
55
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3146' AND Sc_No='9370' AND Seq_No='2' AND Item_Code='CH-327E-24' AND Shortage_Qty='1' AND PO_No='IF-4978'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3155' AND Sc_No='9359' AND Seq_No='1' AND Item_Code='CH-327E-26' AND Shortage_Qty='1' AND PO_No='IF-4970'
59
60
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3157' AND Sc_No='20047' AND Seq_No='2' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5004'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3175' AND Sc_No='20126' AND Seq_No='1' AND Item_Code='MX-625-8' AND Shortage_Qty='1' AND PO_No='IF-5035'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3190' AND Sc_No='20063' AND Seq_No='16' AND Item_Code='DSI2017559FCTY' AND Shortage_Qty='15' AND PO_No='IF-5024'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3184' AND Sc_No='20131' AND Seq_No='4' AND Item_Code='MX-536' AND Shortage_Qty='1' AND PO_No='IF-5049'
71
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3201' AND Sc_No='20162' AND Seq_No='6' AND Item_Code='DSI14212509FBTYLB' AND Shortage_Qty='15' AND PO_No='IF-5085'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3201' AND Sc_No='20162' AND Seq_No='6' AND Item_Code='DSI142125BRAVTUTP' AND Shortage_Qty='15' AND PO_No='IF-5085'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3198' AND Sc_No='20185' AND Seq_No='18' AND Item_Code='TDS-C301-8FOV' AND Shortage_Qty='2' AND PO_No='IF-5098'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3198' AND Sc_No='20200' AND Seq_No='3' AND Item_Code='SP-C208' AND Shortage_Qty='1' AND PO_No='IF-5091'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3206' AND Sc_No='20196' AND Seq_No='3' AND Item_Code='KT-AJ9R' AND Shortage_Qty='1' AND PO_No='IF-5082'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3208' AND Sc_No='20217' AND Seq_No='2' AND Item_Code='MTS-307-2' AND Shortage_Qty='1' AND PO_No='IF-5074'
78
79
80
81
82
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3223' AND Sc_No='20183' AND Seq_No='4' AND Item_Code='DSI142125BRAVTUTP' AND Shortage_Qty='30' AND PO_No='IF-5104'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3223' AND Sc_No='20183' AND Seq_No='4' AND Item_Code='DSI14212509FBTYLB' AND Shortage_Qty='30' AND PO_No='IF-5104'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3204' AND Sc_No='20233' AND Seq_No='3' AND Item_Code='PASO-ML-120L-122.5' AND Shortage_Qty='1' AND PO_No='IF-5077'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3214' AND Sc_No='20178' AND Seq_No='12' AND Item_Code='MTS-291-5' AND Shortage_Qty='1' AND PO_No='IF-5111'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3219' AND Sc_No='20178' AND Seq_No='18' AND Item_Code='WAN700380BRAV48TUTP' AND Shortage_Qty='15' AND PO_No='IF-5121'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3219' AND Sc_No='20178' AND Seq_No='18' AND Item_Code='WAN700381024FBTY' AND Shortage_Qty='15' AND PO_No='IF-5121'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3216' AND Sc_No='20247' AND Seq_No='1' AND Item_Code='MTB-AL-101BT(FOV)' AND Shortage_Qty='1' AND PO_No='IF-5119'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3230' AND Sc_No='20279' AND Seq_No='1' AND Item_Code='PASO-ML-120L-122.5' AND Shortage_Qty='5' AND PO_No='IF-5144'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3246' AND Sc_No='20333' AND Seq_No='9' AND Item_Code='HA-C40-2' AND Shortage_Qty='2' AND PO_No='IF-5167'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3246' AND Sc_No='20422' AND Seq_No='2' AND Item_Code='TDS-D507A-8-FOV' AND Shortage_Qty='1' AND PO_No='IF-5257'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3248' AND Sc_No='20382' AND Seq_No='3' AND Item_Code='WAN70035BRAV48MMTUTP' AND Shortage_Qty='12.5' AND PO_No='IF-5211'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3248' AND Sc_No='20382' AND Seq_No='3' AND Item_Code='WAN700351024FBWFLTY' AND Shortage_Qty='12.5' AND PO_No='IF-5211'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3263' AND Sc_No='20281' AND Seq_No='15' AND Item_Code='SP-C208-V' AND Shortage_Qty='3' AND PO_No='IF-5311'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3278' AND Sc_No='20268' AND Seq_No='37' AND Item_Code='DSI182125BRDVTUTP' AND Shortage_Qty='15' AND PO_No='IF-5141'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3278' AND Sc_No='20268' AND Seq_No='37' AND Item_Code='DSI1819085FBTYLB' AND Shortage_Qty='15' AND PO_No='IF-5141'
83
84
85
86
87
88
89
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3265' AND Sc_No='20430' AND Seq_No='1' AND Item_Code='X10' AND Shortage_Qty='5' AND PO_No='IF-5252'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3276' AND Sc_No='20427' AND Seq_No='11' AND Item_Code='VP-535' AND Shortage_Qty='6' AND PO_No='IF-5460'
91
92
90
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3299' AND Sc_No='20521' AND Seq_No='1' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5399'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3295' AND Sc_No='20521' AND Seq_No='1' AND Item_Code='SP-C208-V' AND Shortage_Qty='1' AND PO_No='IF-5353'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3295' AND Sc_No='20524' AND Seq_No='1' AND Item_Code='SP-C208-V' AND Shortage_Qty='1' AND PO_No='IF-5353'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3306' AND Sc_No='20505' AND Seq_No='2' AND Item_Code='TDS-C301-8-FOV-V' AND Shortage_Qty='2' AND PO_No='IF-5354'
94
95
96
97
98
110
112
113
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3305' AND Sc_No='20413' AND Seq_No='3' AND Item_Code='WAN2021251023BWRLTY' AND Shortage_Qty='0.5' AND PO_No='IF-5269'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3305' AND Sc_No='20413' AND Seq_No='3' AND Item_Code='WAN202125BRAVTUTP' AND Shortage_Qty='0.5' AND PO_No='IF-5269'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3326' AND Sc_No='20638' AND Seq_No='6' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5441'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3328' AND Sc_No='20687' AND Seq_No='1' AND Item_Code='MTS-307-2' AND Shortage_Qty='1' AND PO_No='IF-5498'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3339' AND Sc_No='20536' AND Seq_No='2' AND Item_Code='WAN14212501023FCTY' AND Shortage_Qty='25' AND PO_No='IF-5431'
117
119
120
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3359' AND Sc_No='20517' AND Seq_No='27' AND Item_Code='MTS-C297-5' AND Shortage_Qty='1' AND PO_No='IF-5413'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3341' AND Sc_No='20664' AND Seq_No='6' AND Item_Code='CH-327-26' AND Shortage_Qty='1' AND PO_No='IF-5489'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3356' AND Sc_No='20705' AND Seq_No='6' AND Item_Code='HS-C40-2' AND Shortage_Qty='4' AND PO_No='IF-5582'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3348' AND Sc_No='20542' AND Seq_No='3' AND Item_Code='WAN1621251023BWBRLTY' AND Shortage_Qty='12.5' AND PO_No='IF-5638'
123
124
125
126
127
128
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3376' AND Sc_No='20723' AND Seq_No='1' AND Item_Code='CH-327E-20' AND Shortage_Qty='1' AND PO_No='IF-5609'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3383' AND Sc_No='20724' AND Seq_No='3' AND Item_Code='TDS-C308-8' AND Shortage_Qty='1' AND PO_No='IF-5633'
130
131
132
133
134
135
136
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3403' AND Sc_No='21050' AND Seq_No='1' AND Item_Code='DB-330R' AND Shortage_Qty='2' AND PO_No='IF-5737'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3403' AND Sc_No='21050' AND Seq_No='1' AND Item_Code='DB-330F' AND Shortage_Qty='2' AND PO_No='IF-5737'
137
138
139
140
141
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3418' AND Sc_No='21399' AND Seq_No='1' AND Item_Code='MTS-307-2' AND Shortage_Qty='1' AND PO_No='IF-6475'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3421' AND Sc_No='21217' AND Seq_No='9' AND Item_Code='HA-C40-2' AND Shortage_Qty='1' AND PO_No='IF-5823'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3423' AND Sc_No='21386' AND Seq_No='3' AND Item_Code='X10' AND Shortage_Qty='2' AND PO_No='IF-5865'
142
143
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3428' AND Sc_No='21456' AND Seq_No='1' AND Item_Code='X10' AND Shortage_Qty='10' AND PO_No='IF-6087'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3434' AND Sc_No='21380' AND Seq_No='19' AND Item_Code='Z1-WIDE' AND Shortage_Qty='2' AND PO_No='IF-5992'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3436' AND Sc_No='21392' AND Seq_No='3' AND Item_Code='MTB-AL-3500BT' AND Shortage_Qty='1' AND PO_No='IF-5985'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3442' AND Sc_No='21381' AND Seq_No='1' AND Item_Code='SP-C208' AND Shortage_Qty='1' AND PO_No='IF-5971'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3447' AND Sc_No='21369' AND Seq_No='9' AND Item_Code='CH-565-27.5-AMS' AND Shortage_Qty='1' AND PO_No='IF-6163'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3452' AND Sc_No='21463' AND Seq_No='5' AND Item_Code='KT-TD7F' AND Shortage_Qty='2' AND PO_No='IF-6120'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3454' AND Sc_No='21368' AND Seq_No='9' AND Item_Code='HA-C40-5-V' AND Shortage_Qty='1' AND PO_No='IF-6162'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3460' AND Sc_No='21463' AND Seq_No='1' AND Item_Code='KT-305RB' AND Shortage_Qty='1' AND PO_No='IF-6120'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3461' AND Sc_No='21464' AND Seq_No='5' AND Item_Code='XC-105' AND Shortage_Qty='4' AND PO_No='IF-6130'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3462' AND Sc_No='21465' AND Seq_No='3' AND Item_Code='TY813' AND Shortage_Qty='1' AND PO_No='IF-6132'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3468' AND Sc_No='23028' AND Seq_No='3' AND Item_Code='CH-327-24' AND Shortage_Qty='1' AND PO_No='IF-6643'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3472' AND Sc_No='23006' AND Seq_No='2' AND Item_Code='TY813' AND Shortage_Qty='2' AND PO_No='IF-6631'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3473' AND Sc_No='23006' AND Seq_No='2' AND Item_Code='XC-105' AND Shortage_Qty='2' AND PO_No='IF-6633'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3484' AND Sc_No='23004' AND Seq_No='2' AND Item_Code='HS-C60-2' AND Shortage_Qty='2' AND PO_No='IF-6617'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3484' AND Sc_No='23037' AND Seq_No='6' AND Item_Code='MTB-AL-152BT' AND Shortage_Qty='1' AND PO_No='IF-6655'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3504' AND Sc_No='24039' AND Seq_No='4' AND Item_Code='SP-C208' AND Shortage_Qty='2' AND PO_No='IF-6800'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3504' AND Sc_No='24039' AND Seq_No='6' AND Item_Code='TDS-C41-8' AND Shortage_Qty='1' AND PO_No='IF-6800'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3515' AND Sc_No='24026' AND Seq_No='1' AND Item_Code='AT-83' AND Shortage_Qty='1' AND PO_No='IF-6764'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3527' AND Sc_No='24068' AND Seq_No='1' AND Item_Code='NR-14' AND Shortage_Qty='2' AND PO_No='IF-6914'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3527' AND Sc_No='24068' AND Seq_No='7' AND Item_Code='NR-14' AND Shortage_Qty='1' AND PO_No='IF-6914'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3528' AND Sc_No='24066' AND Seq_No='1' AND Item_Code='TY813' AND Shortage_Qty='1' AND PO_No='IF-6916'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3521' AND Sc_No='24061' AND Seq_No='1' AND Item_Code='GOAL-120L-122MM' AND Shortage_Qty='3' AND PO_No='IF-6855'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3534' AND Sc_No='25021' AND Seq_No='6' AND Item_Code='CH-327E-26' AND Shortage_Qty='1' AND PO_No='IF-6952'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3544' AND Sc_No='25049' AND Seq_No='2' AND Item_Code='TDS-D507A-8-FOV' AND Shortage_Qty='1' AND PO_No='IF-6987'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3557' AND Sc_No='25079' AND Seq_No='11' AND Item_Code='CH-565D-27.5-AMS' AND Shortage_Qty='1' AND PO_No='IF-7060'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3565' AND Sc_No='25080' AND Seq_No='1' AND Item_Code='MTB-AL-153BT' AND Shortage_Qty='8' AND PO_No='IF-7056'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3565' AND Sc_No='25095' AND Seq_No='1' AND Item_Code='SP-C208' AND Shortage_Qty='1' AND PO_No='IF-7113'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3572' AND Sc_No='25122' AND Seq_No='5' AND Item_Code='XC-989' AND Shortage_Qty='2' AND PO_No='IF-7191'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3572' AND Sc_No='25122' AND Seq_No='5' AND Item_Code='XC-105' AND Shortage_Qty='2' AND PO_No='IF-7191'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3574' AND Sc_No='25088' AND Seq_No='1' AND Item_Code='CH-327E-24' AND Shortage_Qty='1' AND PO_No='IF-7195'
SELECT * FROM Fixed_Comments_Shortage WHERE Inv_No='SIF-3584' AND Sc_No='25129' AND Seq_No='12' AND Item_Code='SP-C255' AND Shortage_Qty='1' AND PO_No='IF-7219'
84