oracle ·µ»ØÒ»¸öjava¶ÔÏ󣬺ͷµ»Ø¶à¸öjava¶ÔÏóµÄ·½·¨

·µ»Ø¶à¸ö¶ÔÏó£º
    PROCEDURE AUTO_SEL_INVOICE_DETAIL(
  P_RESULT_LIST OUT SYS_REFCURSOR) AS
    BEGIN
    OPEN P_RESULT_LIST FOR
   SELECT DISTINCT CC.CHARGE_COLLECTION_ID CHARGE_COLLECTION_ID, CC.COLLECT_DATE COLLECT_DATE, CC.TOTAL_AMOUNT TOTAL_AMOUNT, CC.STATEMENT_NO STATEMENT_NO, CC.PORT_CODE PORT_CODE, CC.CUSTOMER_TYPE CUSTOMER_TYPE, CC.CUSTOMER_CODE CUSTOMER_CODE, CC.CUSTOMER_NAME CUSTOMER_NAME, CP.PAYER_TYPE PAYER_TYPE, CP.PAYER_CODE PAYER_CODE, CP.PAYER_NAME PAYER_NAME, CC.ROTATION_NO ROTATION_NO, CD.CHARGE_TYPE_ID CHARGE_TYPE_ID, CD.CHARGE_TYPE CHARGE_TYPE, CD.CARGO_CATEGORY_ID CARGO_CATEGORY_ID, CD.CARGO_CATEGORY CARGO_CATEGORY, CD.TARIFF_CODE_ID TARIFF_CODE_ID, TC.TARIFF_CODE TARIFF_CODE, CD.TARIFF_RATE_ID TARIFF_RATE_ID, CD.TARIFF_RATE TARIFF_RATE, TR.APPLY_TO UOM, CD.SHORT_CODE SHORT_CODE, CD.QUANTITY QUANTITY, CD.TARIFF_AMOUNT TARIFF_AMOUNT, CD.BRN_NO BRN_NO, CD.BOL_NO BOL_NO, CD.SRN_NO SRN_NO,
             CD.TER_ID TER_ID, CD.TER_DETAIL_ID TER_DETAIL_ID, CD.TER_CODE TER_NO, CD.TER_RATE TER_RATE, CD.TER_AMOUNT TER_AMOUNT, CD.NET_AMOUNT NET_AMOUNT, CC.TERMINAL_ID TERMINAL_ID, BB.LINE_CODE LINE_CODE, CD.TRADE_CODE TRADE_CODE, TC.ACTIVITY_CODE OPER_EVENT, CD.BOE_NO BOE_NO, EB.DEST_PORT EX_DESC_PORT, BOL.DEST_PORT IM_DEST_PORT, BOL.ORIGIN_PORT ORIGIN_PORT, EB.DISCHG_PORT_1 DISCHG_PORT_1, BOL.COM_CODE COM_CODE, CC.CREATED_BY CREATED_BY, CC.CREATED_DATE CREATED_DATE
            from GCB_CHARGE_COLLECTION CC INNER JOIN GCB_CHARGE_DTLS CD ON CC.CHARGE_COLLECTION_ID = CD.CHARGE_COLLECTION_ID INNER JOIN GCB_TARIFF_CODE TC ON CD.TARIFF_CODE_ID = TC.TARIFF_CODE_ID INNER JOIN GCB_TARIFF_RATE TR ON CD.TARIFF_RATE_ID = TR.TARIFF_RATE_ID LEFT JOIN GCB_CHARGE_PAYMENT CP ON CC.CHARGE_COLLECTION_ID = CP.CHARGE_COLLECTION_ID LEFT JOIN BERTH_BOOKING BB ON CC.ROTATION_NO = BB.ROTATION