Number of rows fetched with CROSSTAB query

SELECT *

 FROM CROSSTAB (

 $$

 SELECT

--                             PART.run_id,  -- as LOTID                                                                               -- 1

--                             SPLIT_PART ( PART.SERIAL_NUMBER, ':', 1 ),    --2  (SN2)

--                             SPLIT_PART ( PART.SERIAL_NUMBER, ':', 2 ),          -- 3 Temperature 3

                               PART.SERIAL_NUMBER,                                                                                 -- 4 SN1

        PART.DATE1,

                               START_TIME_NUMERIC,         STOP_TIME_NUMERIC,         TEST_ACTION,

        PART_TYPE,          SYSTEM_ID,         FIXTURE_ID,         OPERATOR_ID,

        PART.RUN_ID,         AUXID1_BUILD_ID,         AUXID2_ASIC_ID,

                                PART_PF,

        TESTC.TEST_NUMBER,

        CASE WHEN TRESULT.TEST_RESULT =                             1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

                                                                THEN     (                              CASE WHEN TRESULT.TEST_RESULT BETWEEN TESTC.LIMIT_LOW AND TESTC.LIMIT_HIGH

                                                                                                                                                THEN '1 :-  1e+99'::text

                                                                                                                                                ELSE '0 :-  1e+99'::text

                                                                                                                                END

                                                                                                )

                                                                ELSE       (                              CASE WHEN TRESULT.TEST_RESULT BETWEEN TESTC.LIMIT_LOW AND TESTC.LIMIT_HIGH

                                                                                                                                                                THEN '1 :- ' ||TRESULT.TEST_RESULT::text 

                                                                                                                                                                ELSE '0 :- ' ||TRESULT.TEST_RESULT::text 

                                                                                                                                END

                                                                                                )

                                END AS TEST_RESULT

 FROM bronx.TEST_PART_DETAILS_ALL_MCM_INIT PART, bronx.TEST_RESULTS_ALL_MCM_INIT TRESULT, bronx.TEST_TEST_DETAILS_ALL_MCM_INIT TESTC

WHERE PART.TEST_PART_DET_ALL_MCM_ID                                                                                                       = TRESULT.TEST_PART_DETAILS_ALL_MCM_ID

 AND TRESULT.TEST_TEST_DETAILS_ALL_MCM_ID                                                                                              = TESTC.TEST_TEST_DETAILS_ALL_MCM_ID

 and PART.STAGE                                                                                                                                                                                              = 'FT'

               AND TO_DATE(SPLIT_PART (DATE1, ' ', 1 ), 'MM/DD/YYYY')             = '2023-12-06'

ORDER BY PART.SERIAL_NUMBER , TESTC.TEST_NUMBER 

 $$ ,

$$  SELECT DISTINCT TESTC.TEST_NUMBER

 FROM bronx.TEST_PART_DETAILS_ALL_MCM_INIT PART,

 bronx.TEST_RESULTS_ALL_MCM_INIT TRESULT,

 bronx.TEST_TEST_DETAILS_ALL_MCM_INIT TESTC

WHERE PART.TEST_PART_DET_ALL_MCM_ID                                                                                                                        = TRESULT.TEST_PART_DETAILS_ALL_MCM_ID

                                AND TRESULT.TEST_TEST_DETAILS_ALL_MCM_ID                                                                = TESTC.TEST_TEST_DETAILS_ALL_MCM_ID

                                AND TO_DATE(SPLIT_PART (DATE1, ' ', 1 ), 'MM/DD/YYYY')             = '2023-12-06'

and PART.STAGE                                                                                                                                                                                                              = 'FT'

ORDER BY TESTC.TEST_NUMBER

 $$ )  as ConcatenatedResults (

--                                                                                                                            LOT_ID character varying(20),   --1

--                                                                                                                            SN2 TEXT,                                                                                                --2  (SN2)

--                                                                                                                             Temperature TEXT,                                                                           -- 3

                                                                                                                               SN  TEXT,                                                                                                               -- 4

                                                                                                                               DATE1 Date,

                                                                                                                                START_TIME_NUMERIC NUMERIC,  STOP_TIME_NUMERIC NUMERIC,

                                                                                                                                TEST_ACTION TEXT,

 PART_TYPE TEXT, SYSTEM_ID TEXT, FIXTURE_ID  TEXT, OPERATOR_ID TEXT,

 RUN_ID TEXT, AUXID1_BUILD_ID TEXT, AUXID2_ASIC_ID TEXT,

                                                                                                                                PART_PF TEXT, 

TEST1P1 text, TEST1P2 text, TEST1P3 text, TEST1P4 text, TEST1P5 text, TEST1P6 text, TEST1P7 text, TEST1P8 text, TEST1P9 text, TEST2P1 text, TEST2P10 text, TEST2P100 text, TEST2P101 text, TEST2P102 text, TEST2P103 text, TEST2P104 text, TEST2P105 text, TEST2P106 text, TEST2P107 text, TEST2P108 text, TEST2P109 text, TEST2P11 text, TEST2P110 text, TEST2P111 text, TEST2P112 text, TEST2P113 text, TEST2P114 text, TEST2P115 text, TEST2P116 text, TEST2P117 text, TEST2P118 text, TEST2P119 text, TEST2P12 text, TEST2P120 text, TEST2P121 text, TEST2P122 text, TEST2P123 text, TEST2P124 text, TEST2P125 text, TEST2P126 text, TEST2P127 text, TEST2P128 text, TEST2P129 text, TEST2P13 text, TEST2P130 text, TEST2P131 text, TEST2P132 text, TEST2P133 text, TEST2P134 text, TEST2P135 text, TEST2P136 text, TEST2P137 text, TEST2P138 text, TEST2P139 text, TEST2P14 text, TEST2P140 text, TEST2P141 text, TEST2P142 text, TEST2P143 text, TEST2P144 text, TEST2P145 text, TEST2P146 text, TEST2P147 text, TEST2P148 text, TEST2P149 text, TEST2P15 text, TEST2P16 text, TEST2P17 text, TEST2P18 text, TEST2P19 text, TEST2P2 text, TEST2P20 text, TEST2P21 text, TEST2P22 text, TEST2P23 text, TEST2P24 text, TEST2P25 text, TEST2P26 text, TEST2P27 text, TEST2P28 text, TEST2P29 text, TEST2P3 text, TEST2P30 text, TEST2P31 text, TEST2P32 text, TEST2P33 text, TEST2P34 text, TEST2P35 text, TEST2P36 text, TEST2P37 text, TEST2P38 text, TEST2P39 text, TEST2P4 text, TEST2P40 text, TEST2P41 text, TEST2P42 text, TEST2P43 text, TEST2P44 text, TEST2P45 text, TEST2P46 text, TEST2P47 text, TEST2P48 text, TEST2P49 text, TEST2P5 text, TEST2P50 text, TEST2P51 text, TEST2P52 text, TEST2P53 text, TEST2P54 text, TEST2P55 text, TEST2P56 text, TEST2P57 text, TEST2P58 text, TEST2P59 text, TEST2P6 text, TEST2P60 text, TEST2P61 text, TEST2P62 text, TEST2P63 text, TEST2P64 text, TEST2P65 text, TEST2P66 text, TEST2P67 text, TEST2P68 text, TEST2P69 text, TEST2P7 text, TEST2P70 text, TEST2P71 text, TEST2P72 text, TEST2P73 text, TEST2P74 text, TEST2P75 text, TEST2P76 text, TEST2P77 text, TEST2P78 text, TEST2P79 text, TEST2P8 text, TEST2P80 text, TEST2P81 text, TEST2P82 text, TEST2P83 text, TEST2P84 text, TEST2P85 text, TEST2P86 text, TEST2P87 text, TEST2P88 text, TEST2P89 text, TEST2P9 text, TEST2P90 text, TEST2P91 text, TEST2P92 text, TEST2P93 text, TEST2P94 text, TEST2P95 text, TEST2P96 text, TEST2P97 text, TEST2P98 text, TEST2P99 text, TEST3P1 text, TEST3P10 text, TEST3P2 text, TEST3P3 text, TEST3P4 text, TEST3P5 text, TEST3P6 text, TEST3P7 text, TEST3P8 text, TEST3P9 text

);

I am mainly working with the lines 1,2, 3 and 4. whenever I am commenting or uncommenting, I am doing that at 2 locations.

If I do not comment any lines, I am getting 5 rows.

If I comment only line 1, I am getting only lines 111

If I comment only line 2, I am getting only lines 5

If I comment line 1 and line 2, I am getting 431 lines.

If I comment line 1, line 2 and line 3, I am getting 433 lines.

If I comment line 1, line 2, line 3 and line 4, I am getting only  line row data.

I am expecting in all the above scenarios 433 row lines of data.

What is the piece of information which I am missing here?

Thanks for your help,

Sarwar