好长的SQL

SELECT CUS, CARTONNO, STYLENO, STYLEDESC, COLOR, SIZ, SUM(QTY) QTY, SIZRUN, SEQ FROM
                                    (
                                     SELECT CUS, CARTONNO, STYLENO, B21JCUSNAM STYLEDESC, COLOR, SIZ, QTY, SIZRUN, SEQ FROM
                                     (
                                      SELECT I49GCUS CUS, I49GCTNNUM CARTONNO,
                                      TO_CHAR(CASE WHEN I49GTYP = 'Others' THEN I49GITM ELSE SUBSTR(I49GITM,1,14) END ) STYLENO,
                                      TO_CHAR(CASE WHEN I49GTYP = 'Others' THEN '' ELSE SUBSTR(I49GITM,15,3) END ) COLOR,
                                      TO_CHAR(CASE WHEN I49GTYP = 'Others' THEN '' ELSE SUBSTR(I49GITM,18) END ) SIZ,
                                      (SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = SUBSTR(I49GITM,1,14) AND B21CURFLG ='Y') SIZRUN,
                                      I49GQTY QTY , CASE WHEN I49GTYP = 'Others' THEN 2 ELSE 1 END SEQ
                                      FROM ZTI49G, ZTF14A, ZTF14C
                                      WHERE I49GCOMCOD = F14CCOMCOD AND I49GFRMSTOCOD = F14CPLFRMSTO AND I49GPLNUM = F14CPLNUM AND I49GPLVER = F14CPLVER
                                      AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                      AND F14ATYP = 'PL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                        + @"), ( SELECT B21JPLUNUM, B21JCUSNAM FROM ZTB21J, ZTM100 WHERE B21JMKTCOD(+) = M100ORDMKT AND M100FRNCOD = :FRNCOD )
                                     WHERE B21JPLUNUM(+) = STYLENO
                                    UNION ALL
                                     SELECT CUS, CARTONNO, STYLENO, B21JCUSNAM STYLEDESC, COLOR, SIZ, QTY, SIZRUN, SEQ FROM
                                     (
                                      SELECT I49ACOMCOD, I49AFRMSTOCOD, I49APLNUM, I49APLVER, '' CUS, NVL(M33MNFLET, 'XXX') || '001' CARTONNO, TO_CHAR(F14CREFPLUNUM) STYLENO, TO_CHAR(I49BCOLCOD) COLOR,
                                      TO_CHAR(I49BSIZCOD) SIZ,(SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = F14CREFPLUNUM AND B21CURFLG ='Y') SIZRUN, I49BCFMQTY QTY, 1 SEQ
                                      FROM ZTF14A, ZTF14C, ZTI49A, ZTI49B, ZTM33
                                      WHERE F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                            AND F14ATYP = 'PL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @"AND M33MNFCOD(+) = I49AMNFCOD AND I49ACOMCOD = F14ACOMCOD AND I49AFRMSTOCOD = F14AFRMSTOCOD AND I49APLNUM = F14ADOCNUM AND I49APLVER = F14ADOCVER AND I49APLUNUM = F14CREFPLUNUM
                                      AND I49BCOMCOD = I49ACOMCOD AND I49BFRMSTOCOD = I49AFRMSTOCOD AND I49BPLNUM = I49APLNUM AND I49BPLVER = I49APLVER AND I49BALINNUM = I49ALINNUM
                                     UNION ALL
                                      SELECT I49ACOMCOD, I49AFRMSTOCOD, I49APLNUM, I49APLVER, '' CUS, NVL(M33MNFLET, 'XXX') || '001' CARTONNO, TO_CHAR(F14BITMDSC) STYLENO, TO_CHAR('') COLOR, TO_CHAR('') SIZ, '' SIZRUN, F14BQTY QTY, 2
                                      FROM ZTF14A, ZTF14B, ZTF14C, ZTI49A, ZTM33
                                      WHERE F14ACOMCOD = F14BCOMCOD  AND F14AFRNCOD = F14BFRNCOD AND F14APNNUM = F14BPNNUM AND F14APNVER = F14BPNVER AND F14ALINNUM = F14BALINNUM
                                      AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                            AND F14ATYP = 'PL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @"AND M33MNFCOD(+) = I49AMNFCOD AND I49ACOMCOD = F14ACOMCOD AND I49AFRMSTOCOD = F14AFRMSTOCOD AND I49APLNUM = F14ADOCNUM AND I49APLVER = F14ADOCVER AND I49APLUNUM = F14CREFPLUNUM
                                     UNION ALL
                                      SELECT I49ACOMCOD, I49AFRMSTOCOD, I49APLNUM, I49APLVER, '' CUS, NVL(M33MNFLET, 'XXX') || '001' CARTONNO, TO_CHAR(F14FSAMPLUNUM) STYLENO, TO_CHAR(F14FSAMCOLCOD) COLOR,
                                      TO_CHAR(F14FSAMSIZCOD) SIZ, (SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = F14FSAMPLUNUM AND B21CURFLG ='Y') SIZRUN, F14FSAMQTY QTY, 1
                                      FROM ZTF14A, ZTF14F, ZTF14C, ZTI49A, ZTM33
                                      WHERE F14ACOMCOD = F14FCOMCOD  AND F14AFRNCOD = F14FFRNCOD AND F14APNNUM = F14FPNNUM AND F14APNVER = F14FPNVER AND F14ALINNUM = F14FALINNUM
                                      AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                            AND F14ATYP = 'PL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @"AND M33MNFCOD(+) = I49AMNFCOD AND I49ACOMCOD = F14ACOMCOD AND I49AFRMSTOCOD = F14AFRMSTOCOD AND I49APLNUM = F14ADOCNUM AND I49APLVER = F14ADOCVER AND I49APLUNUM = F14CREFPLUNUM
                                     ), ( SELECT B21JPLUNUM, B21JCUSNAM FROM ZTB21J, ZTM100 WHERE B21JMKTCOD(+) = M100ORDMKT AND M100FRNCOD = :FRNCOD )
                                     WHERE B21JPLUNUM(+) = STYLENO
                                     AND NOT EXISTS ( SELECT 1 FROM ZTI49G WHERE I49GCOMCOD = I49ACOMCOD AND I49GFRMSTOCOD = I49AFRMSTOCOD AND I49GPLNUM = I49APLNUM AND I49GPLVER = I49APLVER )
                                    )
                                    GROUP BY CUS, CARTONNO, STYLENO, STYLEDESC, COLOR, SIZ, SIZRUN, SEQ
UNION ALL
                                    SELECT CUS, CARTONNO, STYLENO, STYLEDESC, COLOR, SIZ, SUM(QTY) QTY, SIZRUN, SEQ FROM
                                    (
                                     SELECT CUS, CARTONNO, STYLENO, B21JCUSNAM STYLEDESC, COLOR, SIZ, QTY, SIZRUN, SEQ FROM
                                     (
                                      SELECT I49GCUS CUS, I49GCTNNUM CARTONNO,
                                      TO_CHAR(CASE WHEN I49GTYP = 'Others' THEN I49GITM ELSE SUBSTR(I49GITM,1,14) END ) STYLENO,
                                      TO_CHAR(CASE WHEN I49GTYP = 'Others' THEN '' ELSE SUBSTR(I49GITM,15,3) END ) COLOR,
                                      TO_CHAR(CASE WHEN I49GTYP = 'Others' THEN '' ELSE SUBSTR(I49GITM,18) END ) SIZ,
                                      (SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = SUBSTR(I49GITM,1,14) AND B21CURFLG ='Y') SIZRUN,
                                      I49GQTY QTY , CASE WHEN I49GTYP = 'Others' THEN 2 ELSE 1 END SEQ
                                      FROM ZTI49G, ZTF14A, ZTF14C
                                      WHERE I49GCOMCOD = F14CCOMCOD AND I49GFRMSTOCOD = F14CPLFRMSTO AND I49GPLNUM = F14CPLNUM AND I49GPLVER = F14CPLVER
                                      AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                      AND F14ATYP = 'BL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                        + @"), ( SELECT B21JPLUNUM, B21JCUSNAM FROM ZTB21J, ZTM100 WHERE B21JMKTCOD(+) = M100ORDMKT AND M100FRNCOD = :FRNCOD )
                                     WHERE B21JPLUNUM(+) = STYLENO
                                    UNION ALL
                                     SELECT CUS, CARTONNO, STYLENO, B21JCUSNAM STYLEDESC, COLOR, SIZ, QTY, SIZRUN, SEQ  FROM
                                     (
                                      SELECT I49ACOMCOD, I49AFRMSTOCOD, I49APLNUM, I49APLVER, '' CUS, NVL(M33MNFLET, 'XXX') || '001' CARTONNO, TO_CHAR(F14CREFPLUNUM) STYLENO, TO_CHAR(I49BCOLCOD) COLOR,
                                      TO_CHAR(I49BSIZCOD) SIZ,(SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = F14CREFPLUNUM AND B21CURFLG ='Y') SIZRUN, I49BCFMQTY QTY, 1 SEQ
                                      FROM ZTF14A, ZTF14C, ZTI50A, ZTI49A, ZTI49B, ZTM33
                                      WHERE F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                            AND F14ATYP = 'BL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @"AND I50ACOMCOD = F14ACOMCOD AND I50AFRMSTOCOD = F14AFRMSTOCOD AND I50ABLNUM = F14ADOCNUM AND I50ABLVER = F14ADOCVER
                                      AND M33MNFCOD(+) = I49AMNFCOD AND I49ACOMCOD = I50ACOMCOD AND I49AFRMSTOCOD = I50AFRMSTOCOD AND I49APLNUM = I50APLNUM AND I49APLVER = I50APLVER AND I49APLUNUM = F14CREFPLUNUM
                                      AND I49BCOMCOD = I49ACOMCOD AND I49BFRMSTOCOD = I49AFRMSTOCOD AND I49BPLNUM = I49APLNUM AND I49BPLVER = I49APLVER AND I49BALINNUM = I49ALINNUM
                                     UNION ALL
                                      SELECT I49ACOMCOD, I49AFRMSTOCOD, I49APLNUM, I49APLVER, '' CUS, NVL(M33MNFLET, 'XXX') || '001' CARTONNO, TO_CHAR(F14BITMDSC) STYLENO, TO_CHAR('') COLOR, TO_CHAR('') SIZ, '' SIZRUN, F14BQTY QTY, 2
                                      FROM ZTF14A, ZTF14B, ZTF14C, ZTI50A, ZTI49A, ZTM33
                                      WHERE F14ACOMCOD = F14BCOMCOD  AND F14AFRNCOD = F14BFRNCOD AND F14APNNUM = F14BPNNUM AND F14APNVER = F14BPNVER AND F14ALINNUM = F14BALINNUM
                                      AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                            AND F14ATYP = 'BL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @"AND I50ACOMCOD = F14ACOMCOD AND I50AFRMSTOCOD = F14AFRMSTOCOD AND I50ABLNUM = F14ADOCNUM AND I50ABLVER = F14ADOCVER
                                      AND M33MNFCOD(+) = I49AMNFCOD AND I49ACOMCOD = I50ACOMCOD AND I49AFRMSTOCOD = I50AFRMSTOCOD AND I49APLNUM = I50APLNUM AND I49APLVER = I50APLVER AND I49APLUNUM = F14CREFPLUNUM
                                     UNION ALL
                                      SELECT I49ACOMCOD, I49AFRMSTOCOD, I49APLNUM, I49APLVER, '' CUS, NVL(M33MNFLET, 'XXX') || '001' CARTONNO, TO_CHAR(F14FSAMPLUNUM) STYLENO, TO_CHAR(F14FSAMCOLCOD) COLOR,
                                      TO_CHAR(F14FSAMSIZCOD) SIZ, (SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = F14FSAMPLUNUM AND B21CURFLG ='Y') SIZRUN, F14FSAMQTY QTY, 1
                                      FROM ZTF14A, ZTF14F, ZTF14C, ZTI50A, ZTI49A, ZTM33
                                      WHERE F14ACOMCOD = F14FCOMCOD  AND F14AFRNCOD = F14FFRNCOD AND F14APNNUM = F14FPNNUM AND F14APNVER = F14FPNVER AND F14ALINNUM = F14FALINNUM
                                      AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                            AND F14ATYP = 'BL' AND (F14CCOMCOD, F14CFRNCOD, F14CPNNUM, F14CPNVER) IN "
                                            + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @"AND I50ACOMCOD = F14ACOMCOD AND I50AFRMSTOCOD = F14AFRMSTOCOD AND I50ABLNUM = F14ADOCNUM AND I50ABLVER = F14ADOCVER
                                      AND M33MNFCOD(+) = I49AMNFCOD AND I49ACOMCOD = I50ACOMCOD AND I49AFRMSTOCOD = I50AFRMSTOCOD AND I49APLNUM = I50APLNUM AND I49APLVER = I50APLVER AND I49APLUNUM = F14CREFPLUNUM
                                     ), ( SELECT B21JPLUNUM, B21JCUSNAM FROM ZTB21J, ZTM100 WHERE B21JMKTCOD(+) = M100ORDMKT AND M100FRNCOD = :FRNCOD )
                                     WHERE B21JPLUNUM(+) = STYLENO
                                     AND NOT EXISTS ( SELECT 1 FROM ZTI49G WHERE I49GCOMCOD = I49ACOMCOD AND I49GFRMSTOCOD = I49AFRMSTOCOD AND I49GPLNUM = I49APLNUM AND I49GPLVER = I49APLVER )
                                    )
                                    GROUP BY CUS, CARTONNO, STYLENO, STYLEDESC, COLOR, SIZ, SIZRUN, SEQ
UNION ALL
                                    SELECT '' CUS,
                                    NVL(
                                     (
                                      SELECT TRIM(M33MNFLET) || '001'
                                      FROM ZTI40, ZTM33
                                      WHERE M33COMCOD = I40COMCOD AND M33MNFCOD = I40MNFCOD AND I40COMCOD = F14ACOMCOD AND I40STOCOD = F14AFRMSTOCOD AND I40GRNUM = F14ADOCNUM AND I40CURFLG = 'Y' AND I40STS IN ('050', '380')
                                     ),
                                        (
                                      SELECT
                                      (
                                       CASE WHEN CARTONNO = '0' THEN
                                       (SELECT (CASE WHEN CARTONNO = '1' THEN
                                        (
                                         SELECT DISTINCT TRIM(M33MNFLET)
                                         FROM ZTD12, ZTD12A, ZTF14A, ZTF14C, ZTM100, ZTM33
                                         WHERE D12COMCOD = D12ACOMCOD AND D12PCNUM = D12APCNUM AND D12PCVER = D12APCVER AND D12CURFLG = 'Y' AND D12STS = '050'
                                         AND M33COMCOD = D12COMCOD AND M33MNFCOD = D12MNFCOD AND M100FRNCOD = F14AFRNCOD AND M100ORDMKT = D12AMKTCOD  AND D12COMCOD = F14CCOMCOD AND D12PLUNUM = F14CREFPLUNUM
                                         AND F14ACOMCOD = F14CCOMCOD AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                                        AND F14ATYP = 'GR' AND (F14ACOMCOD, F14AFRNCOD, F14APNNUM, F14APNVER) IN "
                                                        + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                                    + @") || '001' ELSE 'XXX001' END ) CARTONNO
                                        FROM
                                        (
                                         SELECT (CASE WHEN COUNT(DISTINCT TRIM(M33MNFLET)) = 0 THEN '0' WHEN COUNT(DISTINCT TRIM(M33MNFLET)) = 1 THEN '1' WHEN COUNT(DISTINCT TRIM(M33MNFLET)) > 1 THEN 'XXX001' END) CARTONNO
                                         FROM ZTD12, ZTD12A, ZTF14A, ZTF14C, ZTM100, ZTM33
                                         WHERE D12COMCOD = D12ACOMCOD AND D12PCNUM = D12APCNUM AND D12PCVER = D12APCVER AND D12CURFLG = 'Y' AND D12STS = '050'
                                         AND M33COMCOD = D12COMCOD AND M33MNFCOD = D12MNFCOD AND M100FRNCOD = F14AFRNCOD AND M100ORDMKT <> D12AMKTCOD  AND D12COMCOD = F14CCOMCOD AND D12PLUNUM = F14CREFPLUNUM
                                         AND F14ACOMCOD = F14CCOMCOD AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                        
                                                        AND F14ATYP = 'GR' AND (F14ACOMCOD, F14AFRNCOD, F14APNNUM, F14APNVER) IN "
                                                        + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                                    + @")
                                       )
                                       WHEN CARTONNO = '1' THEN
                                       (
                                        SELECT DISTINCT TRIM(M33MNFLET)
                                        FROM ZTD12, ZTD12A, ZTF14A, ZTF14C, ZTM100, ZTM33
                                        WHERE D12COMCOD = D12ACOMCOD AND D12PCNUM = D12APCNUM AND D12PCVER = D12APCVER AND D12CURFLG = 'Y' AND D12STS = '050'
                                        AND M33COMCOD = D12COMCOD AND M33MNFCOD = D12MNFCOD AND M100FRNCOD = F14AFRNCOD AND M100ORDMKT = D12AMKTCOD  AND D12COMCOD = F14CCOMCOD AND D12PLUNUM = F14CREFPLUNUM
                                        AND F14ACOMCOD = F14CCOMCOD AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                                    AND F14ATYP = 'GR' AND (F14ACOMCOD, F14AFRNCOD, F14APNNUM, F14APNVER) IN "
                                                    + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                                + @") || '001' WHEN CARTONNO = 'XXX001' THEN 'XXX001' END
                                      ) CARTONNO
                                      FROM
                                      (
                                       SELECT (CASE WHEN COUNT(DISTINCT TRIM(M33MNFLET)) = 0 THEN '0' WHEN COUNT(DISTINCT TRIM(M33MNFLET)) = 1 THEN '1' WHEN COUNT(DISTINCT TRIM(M33MNFLET)) > 1 THEN 'XXX001' END) CARTONNO
                                       FROM ZTD12, ZTD12A, ZTF14A, ZTF14C, ZTM100, ZTM33
                                       WHERE D12COMCOD = D12ACOMCOD AND D12PCNUM = D12APCNUM AND D12PCVER = D12APCVER AND D12CURFLG = 'Y' AND D12STS = '050'
                                       AND M33COMCOD = D12COMCOD AND M33MNFCOD = D12MNFCOD
                                       AND M100FRNCOD = F14AFRNCOD AND M100ORDMKT = D12AMKTCOD
                                       AND D12COMCOD = F14CCOMCOD AND D12PLUNUM = F14CREFPLUNUM
                                       AND F14ACOMCOD = F14CCOMCOD AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                                AND F14ATYP = 'GR' AND (F14ACOMCOD, F14AFRNCOD, F14APNNUM, F14APNVER) IN "
                                                + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                            + @")
                                        )
                                      ) CARTONNO,
                                      F14CREFPLUNUM STYLENO, B21JCUSNAM STYLEDESC, I40ACOL COLOR, I40ASIZ SIZ, I40ARCVQTY QTY, (SELECT B21SIZRUN FROM ZTB21 WHERE B21PLUNUM = F14CREFPLUNUM AND B21CURFLG ='Y') SIZRUN, 1
                                    FROM ZTF14A, ZTF14C, ZTI40A, ( SELECT B21JPLUNUM, B21JCUSNAM FROM ZTB21J, ZTM100 WHERE B21JMKTCOD(+) = M100ORDMKT AND M100FRNCOD = :FRNCOD )
                                    WHERE F14ATYP = 'GR' AND (F14ACOMCOD, F14AFRNCOD, F14APNNUM, F14APNVER) IN "
                                    + Helper.ObjectListSetToOracleExpressionListSet(franchisePaymentNotices.Select(f => new object[] { f.CompanyCode, f.Franchisee.Code, f.DocumentCode, f.Version }))
                                    + @" AND B21JPLUNUM(+) = F14CREFPLUNUM
                                    AND F14ACOMCOD = F14CCOMCOD  AND F14AFRNCOD = F14CFRNCOD AND F14APNNUM = F14CPNNUM AND F14APNVER = F14CPNVER AND F14ALINNUM = F14CALINNUM
                                    AND I40ACOMCOD = F14ACOMCOD AND I40ASTOCOD = F14AFRMSTOCOD AND I40AGRNUM = F14ADOCNUM AND I40AGRVER = F14ADOCVER AND I40APLUNUM = F14CREFPLUNUM
                                    ORDER BY 1, 2, 9, 3, 5, 6