md.PAP = 'A'

mhv.WeightPap * 1

md.PAP = 'B'

mhv.WeightPap * 0.5

md.PAP = 'C'

mhv.WeightPap * 0

md.PAP = 'N/A'

mhv.WeightPap * 0

ELSE

0

md.PPM = 'A'

mhv.WeightPpm * 1

md.PPM = 'B'

mhv.WeightPpm * 0.5

md.PPM = 'C'

mhv.WeightPpm * 0

md.PPM = 'N/A'

mhv.WeightPpm * 0

ELSE

0

md.Vi = 'A'

mhv.WeightVi * 1

md.Vi = 'B'

mhv.WeightVi * 0.5

md.Vi = 'C'

mhv.WeightVi * 0

md.Vi = 'N/A'

mhv.WeightVi * 0

ELSE

0

Subquery: ROW_NUMBER() dan Grup Berdasarkan Jobsite, Section, dll.

Join Tabel: pm.SOSTECH_V, pm.AFU_CONFIGURATION_T, #TblEqWork

Filter Berdasarkan Component, Sub Component, JenisConmon = 'PAP'

LEFT JOIN pm.LIMIT_T untuk RattingLimit

Filter WHERE pap.Number BETWEEN 1 AND 3