SELECT /*+ M600 UI m600308210 후판해송LOT결정우선순위등록 ShipProcPlateShipLotRankingVO DesignedBy 김주영 CreatedBy 김주영 */
    SHIP_HOLD_NO,
    SHIPMENT_GROUP,
    STRE_LOC_CD,
    SUM(PRD_WGT)         AS PRD_WGT, /*전체중량*/
    SUM(PRD_SELECT_WGT)  AS PRD_SELECT_WGT, /*선별량*/
    SUM(PRD_SELECT_WGT)-SUM(PRD_PICK_UP_WGT) AS BALANCE_WGT, /*대상잔량*/
    MAX(YD_PRR_SHIP_RANKING) AS YD_PRR_SHIP_RANKING /*순위*/
FROM
(
    SELECT
        SHIP_HOLD_NO,
        SHIPMENT_GROUP, /*적하그룹*/
        STRE_LOC_CD,
        PRD_WGT,
        DECODE(PLATE_SELECT_ORDER_NO,NULL,0,PRD_WGT) AS PRD_SELECT_WGT,
        DECODE(DELIVERY_LOT_NO,NULL,0,PRD_WGT)       AS PRD_PICK_UP_WGT,       
        YD_PRR_SHIP_RANKING
    FROM
    (
        SELECT
             DELH.PRODUCT_NO
            ,DELH.PRD_PRG_TP
            ,DELH.PLATE_SELECT_ORDER_NO
            ,SUBSTR(DELH.STRE_LOC_CD,1,4) AS STRE_LOC_CD
            ,DELD.DELIVERY_LOT_NO
            ,DELD.SHIP_HOLD_NO
            ,DELD.SHIPMENT_GROUP
            ,DECODE(DELH.WEIGHT_DECISION_CODE,
                            'NA', DELH.PRD_NET_ACTUAL_WGT,
                         'NC', DELH.PRD_NET_THEO_WGT,
                         'GA', DELH.PRD_GR_ACTUAL_WGT,
                         'GC', DELH.PRD_GR_THEO_WGT ) AS PRD_WGT /*중량*/
            ,(CASE WHEN DELD.DELIVERY_LOT_NO IS NULL AND DELH.PLATE_SELECT_ORDER_NO IS NOT NULL THEN
                        DELH.YD_PRR_SHIP_RANKING END) AS YD_PRR_SHIP_RANKING    
        FROM TB_M60_DELH010 DELH
            ,TB_M60_DELD010 DELD
        WHERE   DELD.PRODUCT_NO = DELH.PRODUCT_NO
            AND DELD.LANE_ORIJIN_CD = DELH.LANE_ORIJIN_CD
            AND DELD.PRD_TRUCK_LOADING_SUMUP_DT IS NULL
            AND DELH.PRODUCT_WH_CD = :1
            AND DELD.TRANS_ORDER_NO =:2  /*배선지시번호*/
            AND (SELECT SHIP_TYPE FROM VI_M00_M60A0027 WHERE SHIP_CD=DELD.SHIP_CD AND ROWNUM=1) NOT IN ('R','P')
            AND DECODE(:3,NULL,'2',DELD.SHIP_HOLD_NO) = NVL(:4,'2') /*HOLD*/  
            AND DECODE(:5,NULL,'3',DELD.SHIPMENT_GROUP) = NVL(:6,'3') /*적하그룹*/
            AND DELD.SHIP_HOLD_NO IS NOT NULL
            AND DELD.SHIPMENT_GROUP IS NOT NULL
    )
)
GROUP BY SHIP_HOLD_NO
        ,SHIPMENT_GROUP
        ,STRE_LOC_CD
ORDER BY SHIP_HOLD_NO
        ,SHIPMENT_GROUP
        ,STRE_LOC_CD

SUM(PRD_SELECT_WGT) AS PRD_SELECT_WGT  이항목의 값을

다음의 쿼리문으로 출력을 하고 싶습니다. 도와주세요 ㅠㅠ

SELECT
    'P0' DELIVERY_TXN_HISTORY_TYPE
    ,TRANS_ORDER_NO
    ,MAX(SHIP_NAME)  SHIP_NAME
    ,COUNT(PRODUCT_NO) PRD_CNT /*수량*/
    ,SUM(TRANS_ORDER_WGT) BALANCE_WGT /*잔량*/
    ,MAX(CRANE_NO)   CRANE_NO
    ,MAX(BERTH_CODE)  BERTH_CODE
    ,MAX(CASSETTE_LOADING_YARD_FLAG) CASSETTE_LOADING_YARD_FLAG
    ,MAX(LOADING_VEHICLE_TYPE)    LOADING_VEHICLE_TYPE
    ,TXN_REQUEST_HEADERS_ID
    ,MAX(SHIP_LINE)  SHIP_LINE
    ,MAX(PRODUCT_WH_CD) PRODUCT_WH_CD
    ,MAX(PLT_PDT_SIL_TYPE_TP) PLT_PDT_SIL_TYPE_TP
    ,MAX(LOADING_COMPANY_CD) LOADING_COMPANY_CD
    ,MAX(PLT_CORR_RQST_F) PLT_CORR_RQST_F
    ,MAX(TRANS_EQUIPMENT_CD) TRANS_EQUIPMENT_CD
FROM
(
    SELECT /*+ ORDERED HintedBy IKS */
         TRIP.TXN_REQUEST_HEADERS_ID
        ,STOPP0.DELIVERY_TXN_HISTORY_TYPE
        ,TRIP.TRANS_ORDER_NO
        ,STOPP0.SHIP_HOLD_NO
        ,TRIP.SHIP_CD, (SELECT SHIP_TYPE  FROM VI_M00_M60A0027 WHERE SHIP_CD=TRIP.SHIP_CD) AS SHIP_LINE
        ,(CASE WHEN TRIP.SHIP_CD IS NOT NULL THEN
                (SELECT SHIP_KOR_NAME  FROM VI_M00_M60A0027 WHERE SHIP_CD=TRIP.SHIP_CD)
          END) AS SHIP_NAME /*선명*/
        ,DECODE(STOPP0.ALONGSIDE_PLAN_BERTH_CODE,
                        NULL,STOPP0.LOCATION_BERTH_CODE,
                        STOPP0.ALONGSIDE_PLAN_BERTH_CODE) AS BERTH_CODE /*선석*/
     ,DECODE(DELH.WEIGHT_DECISION_CODE,
                 'NA', DELH.PRD_NET_ACTUAL_WGT,
                 'NC', DELH.PRD_NET_THEO_WGT,
                 'GA', DELH.PRD_GR_ACTUAL_WGT,
                 'GC', DELH.PRD_GR_THEO_WGT,0) AS TRANS_ORDER_WGT /*지시량*/
        ,DELH.PRODUCT_NO
        ,STOPP0.CASSETTE_LOADING_YARD_FLAG /*카세트하역야드구분*/
        ,(CASE WHEN STOPP0.LOADING_VEHICLE_TYPE IS NOT NULL THEN
         (SELECT CD_V_MEANING FROM VI_M00_CODE_ACCESS
          WHERE CD_TP = 'LOADING_VEHICLE_TYPE'
            AND CATEGORY_GROUP_NM = :1
            AND CATEGORY_CD_TP ='LOADING_VEHICLE_TYPE'
            AND CD_V=STOPP0.LOADING_VEHICLE_TYPE)
          END) AS LOADING_VEHICLE_TYPE /*배차유형명*/
       ,(SELECT MAX(CRANE_NO)
          FROM   TB_M60_PLAN010
          WHERE TRANS_ORDER_NO=DELD.TRANS_ORDER_NO AND PLANDO_CODE= 'D'
            AND WORKS_CODE=:2 AND DATA_END_STATUS IS NULL) AS CRANE_NO /*하역기*/
        ,STOPP0.PRODUCT_WH_CD
        ,STOPP0.PLT_PDT_SIL_TYPE_TP
        ,STOPP0.LOADING_COMPANY_CD
        ,DELH.PLT_CORR_RQST_F
        ,TRIP.TRANS_EQUIPMENT_CD
    FROM
         TB_M60_TRIP010  TRIP
        ,(SELECT TXN_REQUEST_HEADERS_ID,DELIVERY_TXN_HISTORY_TYPE,SHIP_HOLD_NO,SHIP_STAT_CD,
                 ALONGSIDE_PLAN_BERTH_CODE,LOCATION_BERTH_CODE,LOADING_COMPANY_CD,
                 LOADING_VEHICLE_TYPE,CASSETTE_LOADING_YARD_FLAG,PRODUCT_WH_CD,PLT_PDT_SIL_TYPE_TP
          FROM TB_M60_STOP010 WHERE DELIVERY_TXN_HISTORY_TYPE='P0' AND DATA_END_STATUS IS NULL
          ) STOPP0
        ,TB_M60_DELD010  DELD
        ,TB_M60_DELH010  DELH
    WHERE DELD.PRODUCT_NO = DELH.PRODUCT_NO
      AND DELD.LANE_ORIJIN_CD = DELH.LANE_ORIJIN_CD
      AND TRIP.TXN_REQUEST_HEADERS_ID = STOPP0.TXN_REQUEST_HEADERS_ID
      AND TRIP.TRANS_ORDER_NO LIKE :3 ||'%'
      AND TRIP.TRANS_ORDER_NO = DELD.TRANS_ORDER_NO
      AND SUBSTR(STOPP0.SHIP_STAT_CD,2,2) IN ('S1','S2','S3','S4') /*수송수단*/
      AND STOPP0.LOADING_COMPANY_CD = :4 /*하역사*/
      AND DECODE(:5, NULL, 'all', DELH.ITEM_TYPE_GROUP_CODE ) = NVL(:6, 'all')
      AND NVL(STOPP0.PRODUCT_WH_CD, 'X') = NVL(:7, NVL(STOPP0.PRODUCT_WH_CD, 'X'))
      AND DELD.TRUCKING_REQUEST_CD IS NULL
      AND TRIP.DATA_END_STATUS IS NULL
      AND DELH.PRD_SHIP_VEHC_SHIP_DN_DT IS NULL
)
GROUP BY TXN_REQUEST_HEADERS_ID
  ,TRANS_ORDER_NO
ORDER BY TXN_REQUEST_HEADERS_ID
  ,TRANS_ORDER_NO