Hi All,
I am Calculating total No.of Steps in a Load Plan and Steps Completed in a load Plan. When i am doing i am getting a count Diff of 300 and there are some maintenance Table Steps are there is there any Filter I can apply on the Below SQL.
---------------------------***********************---------------------------------------------------
SELECT COUNT(B.I_LP_INST) TOTAL_STEPS
FROM SNP_LP_INST A,
SNP_LPI_STEP B
WHERE A.I_LP_INST = B.I_LP_INST
AND B.I_LP_INST =
(SELECT MAX(B.I_LP_INST)
FROM SNP_LP_INST A,
SNP_LPI_STEP B
WHERE A.I_LP_INST = B.I_LP_INST
AND A.LOAD_PLAN_NAME = '*****************************************************'
);
-----------------------************************---------------------------------------------------
SELECT COUNT(C.I_LP_INST) TOTAL_STEPS
FROM SNP_LP_INST A,
SNP_LPI_STEP B,
SNP_LPI_STEP_LOG C
WHERE A.I_LP_INST = B.I_LP_INST
AND B.I_LP_INST = C.I_LP_INST
AND B.I_LP_STEP = C.I_LP_STEP
AND C.STATUS = 'D'
AND B.I_LP_INST =
(SELECT MAX(B.I_LP_INST)
FROM SNP_LP_INST A,
SNP_LPI_STEP B,
SNP_LPI_STEP_LOG C
WHERE A.I_LP_INST = B.I_LP_INST
AND B.I_LP_INST = C.I_LP_INST
AND B.I_LP_STEP = C.I_LP_STEP
AND A.LOAD_PLAN_NAME = '****************************************************');
Please Let me know your Thoughts or any ideas.