HTML报表例子

最新推荐文章于 2021-11-06 16:11:47 发布
最新推荐文章于 2021-11-06 16:11:47 发布
阅读量1.3k 收藏
点赞数
分类专栏： HTML 文章标签： html transactions date header report flv

CREATE OR REPLACE PACKAGE MEW_PO_PRICE_COMPARE_PKG IS

  PROCEDURE MAIN(RETCODE           OUT NUMBER
                ,ERRBUF            OUT VARCHAR2
                ,P_ORGANIZATION_ID VARCHAR2
                ,P_PERIOD_NAME_F   VARCHAR2
                ,P_PERIOD_NAME_T   VARCHAR2);

END;
/
CREATE OR REPLACE PACKAGE BODY MEW_PO_PRICE_COMPARE_PKG IS

  PROCEDURE MAIN(RETCODE           OUT NUMBER
                ,ERRBUF            OUT VARCHAR2
                ,P_ORGANIZATION_ID VARCHAR2
                ,P_PERIOD_NAME_F   VARCHAR2
                ,P_PERIOD_NAME_T   VARCHAR2) IS
    CURSOR C1 IS(
      SELECT A.PERIOD_NAME
            ,C.SEGMENT1 ITEM_NUMBER
            ,C.DESCRIPTION ITEM_DESC
            ,FLV.MEANING ITEM_TYPE --用户物料类型
            ,APPS.MEW_ITEM_GROUP_F(A.ORGANIZATION_ID
                                  ,A.INVENTORY_ITEM_ID
                                  ,'MEW_ACCT'
                                  ,2) ITEM_AUX --部品分类      
            ,A.CURRENCY_CODE --原币币种
            ,A.TRANSACTION_UOM --事务处理单位       
            ,PVSA.VENDOR_SITE_CODE --供应商地点
            ,CIC.ITEM_COST --标准单价
            ,A.TOTAL_TRANSACTION_QUANTITY
            ,A.TOTAL_TRANSACTION_VALUE
            ,A.TOTAL_BASE_TRANSACTION_VALUE
            ,B.TOTAL_TRANSACTION_QUANTITY TOTAL_TRANSACTION_QUANTITY_E
            ,B.TOTAL_TRANSACTION_VALUE TOTAL_TRANSACTION_VALUE_E
            ,B.TOTAL_BASE_TRANSACTION_VALUE TOTAL_BASE_TRANSACTION_VALUE_E
        FROM (SELECT OPV.PERIOD_NAME
                    ,PHA.VENDOR_SITE_ID
                    ,MMT.ORGANIZATION_ID
                    ,MMT.INVENTORY_ITEM_ID
                    ,MMT.TRANSACTION_UOM --事务处理单位
                    ,MMT.CURRENCY_CODE --原币币种
                    ,SUM(MMT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                    ,-SUM(MTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE --原币金额
                    ,-SUM(MTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE --本币金额
                FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
                    ,APPS.PO_HEADERS_ALL            PHA
                    ,APPS.ORG_ACCT_PERIODS_V        OPV
                    ,APPS.MTL_TRANSACTION_ACCOUNTS  MTA
               WHERE MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
                 AND MTA.ACCOUNTING_LINE_TYPE = 5
                 AND MMT.ORGANIZATION_ID = P_ORGANIZATION_ID
                 AND MMT.TRANSACTION_TYPE_ID IN (18
                                                ,36) --PO RECEIPT OR RETURN TO VENDOR
                 AND MMT.TRANSACTION_QUANTITY <> 0
                 AND MMT.TRANSACTION_SOURCE_ID = PHA.PO_HEADER_ID
                 AND MMT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                     OPV.END_DATE + 0.99999
                 AND MMT.ORGANIZATION_ID = OPV.ORGANIZATION_ID
                 AND OPV.PERIOD_NAME = P_PERIOD_NAME_F
                 AND OPV.REC_TYPE = 'ORG_PERIOD'
               GROUP BY OPV.PERIOD_NAME
                       ,PHA.VENDOR_SITE_ID
                       ,MMT.ORGANIZATION_ID
                       ,MMT.INVENTORY_ITEM_ID
                       ,MMT.TRANSACTION_UOM
                       ,MMT.CURRENCY_CODE) A
            ,(SELECT OPV.PERIOD_NAME
                    ,PHA.VENDOR_SITE_ID
                    ,MMT.ORGANIZATION_ID
                    ,MMT.INVENTORY_ITEM_ID
                    ,MMT.TRANSACTION_UOM --事务处理单位
                    ,MMT.CURRENCY_CODE --原币币种
                    ,SUM(MMT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                    ,-SUM(MTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE --原币金额
                    ,-SUM(MTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE --本币金额
                FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
                    ,APPS.PO_HEADERS_ALL            PHA
                    ,APPS.ORG_ACCT_PERIODS_V        OPV
                    ,APPS.MTL_TRANSACTION_ACCOUNTS  MTA
               WHERE MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
                 AND MTA.ACCOUNTING_LINE_TYPE = 5
                 AND MMT.ORGANIZATION_ID = P_ORGANIZATION_ID
                 AND MMT.TRANSACTION_TYPE_ID IN (18
                                                ,36) --PO RECEIPT OR RETURN TO VENDOR
                 AND MMT.TRANSACTION_QUANTITY <> 0
                 AND MMT.TRANSACTION_SOURCE_ID = PHA.PO_HEADER_ID
                 AND MMT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                     OPV.END_DATE + 0.99999
                 AND MMT.ORGANIZATION_ID = OPV.ORGANIZATION_ID
                 AND OPV.PERIOD_NAME = P_PERIOD_NAME_T
                 AND OPV.REC_TYPE = 'ORG_PERIOD'
               GROUP BY OPV.PERIOD_NAME
                       ,PHA.VENDOR_SITE_ID
                       ,MMT.ORGANIZATION_ID
                       ,MMT.INVENTORY_ITEM_ID
                       ,MMT.TRANSACTION_UOM
                       ,MMT.CURRENCY_CODE) B
            ,MTL_SYSTEM_ITEMS_B C
            ,APPS.FND_LOOKUP_VALUES_VL FLV
            ,APPS.PO_VENDOR_SITES_ALL PVSA
            ,APPS.CST_ITEM_COSTS CIC
       WHERE A.VENDOR_SITE_ID = B.VENDOR_SITE_ID(+)
         AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID(+)
         AND A.TRANSACTION_UOM = B.TRANSACTION_UOM(+)
         AND A.CURRENCY_CODE = B.CURRENCY_CODE(+)
         AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
         AND A.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
         AND A.VENDOR_SITE_ID = PVSA.VENDOR_SITE_ID
         AND C.ITEM_TYPE = FLV.LOOKUP_CODE
         AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
         AND A.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID(+)
         AND A.ORGANIZATION_ID = CIC.ORGANIZATION_ID(+)
         AND CIC.COST_TYPE_ID(+) = 1 --Frozen
     
      UNION ALL
     
      SELECT A.PERIOD_NAME
            ,MSI.SEGMENT1 ITEM_NUMBER
            ,MSI.DESCRIPTION ITEM_DESC
            ,FLV.MEANING ITEM_TYPE --用户物料类型
            ,MEW_ITEM_GROUP_F(MSI.ORGANIZATION_ID
                             ,MSI.INVENTORY_ITEM_ID
                             ,'MEW_ACCT'
                             ,2) ITEM_AUX --部品分类
            ,A.CURRENCY_CODE
            ,A.TRANSACTION_UOM
            
            ,PVSA.VENDOR_SITE_CODE
            ,(SELECT MAX(CRCC.RESOURCE_RATE)
                FROM BOM_RESOURCES      BRV
                    ,CST_RESOURCE_COSTS CRCC
               WHERE BRV.ORGANIZATION_ID = A.ORGANIZATION_ID
                 AND BRV.COST_CODE_TYPE IN (3
                                           ,4)
                 AND CRCC.COST_TYPE_ID = 1
                 AND (BRV.PURCHASE_ITEM_ID = A.ITEM_ID)
                 AND BRV.RESOURCE_ID = CRCC.RESOURCE_ID
                 AND BRV.ORGANIZATION_ID = CRCC.ORGANIZATION_ID) ITEM_COST
             --   ,CRC.RESOURCE_RATE     ITEM_COST
            
            ,A.TOTAL_TRANSACTION_QUANTITY
            ,A.TOTAL_TRANSACTION_VALUE
            ,A.TOTAL_BASE_TRANSACTION_VALUE
            ,B.TOTAL_TRANSACTION_QUANTITY   TOTAL_TRANSACTION_QUANTITY_E
            ,B.TOTAL_TRANSACTION_VALUE      TOTAL_TRANSACTION_VALUE_E
            ,B.TOTAL_BASE_TRANSACTION_VALUE TOTAL_BASE_TRANSACTION_VALUE_E
        FROM (SELECT OPV.PERIOD_NAME
                    ,PHA.VENDOR_SITE_ID
                    ,WT.ORGANIZATION_ID
                    ,PLA.ITEM_ID
                     --  ,WT.RESOURCE_ID
                    ,WT.TRANSACTION_UOM
                    ,WT.CURRENCY_CODE
                    ,SUM(WT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                    ,SUM(WTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE
                    ,SUM(WTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE
                FROM WIP_TRANSACTIONS         WT
                    ,WIP_TRANSACTION_ACCOUNTS WTA
                    ,PO_HEADERS_ALL           PHA
                    ,PO_LINES_ALL             PLA
                    ,ORG_ACCT_PERIODS_V       OPV
               WHERE WT.TRANSACTION_ID = WTA.TRANSACTION_ID
                 AND WT.PO_HEADER_ID = PHA.PO_HEADER_ID
                 AND WT.PO_LINE_ID = PLA.PO_LINE_ID
                 AND OPV.ORGANIZATION_ID = WT.ORGANIZATION_ID
                 AND OPV.ACCT_PERIOD_ID = WT.ACCT_PERIOD_ID
                 AND WT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                     OPV.END_DATE + 0.99999
                 AND OPV.REC_TYPE = 'ORG_PERIOD'
                 AND WTA.ACCOUNTING_LINE_TYPE = 7 --WIP 估价
                 AND WT.TRANSACTION_TYPE = 3 --外协加工     
                 AND WT.ORGANIZATION_ID = P_ORGANIZATION_ID
                 AND OPV.PERIOD_NAME = P_PERIOD_NAME_F
               GROUP BY OPV.PERIOD_NAME
                       ,PHA.VENDOR_SITE_ID
                       ,WT.ORGANIZATION_ID
                       ,PLA.ITEM_ID
                        --  ,WT.RESOURCE_ID
                       ,WT.TRANSACTION_UOM
                       ,WT.CURRENCY_CODE) A
            ,(SELECT OPV.PERIOD_NAME
                    ,PHA.VENDOR_SITE_ID
                    ,WT.ORGANIZATION_ID
                    ,PLA.ITEM_ID
                    ,WT.TRANSACTION_UOM
                    ,WT.CURRENCY_CODE
                    ,SUM(WT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                    ,SUM(WTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE
                    ,SUM(WTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE
                FROM WIP_TRANSACTIONS         WT
                    ,WIP_TRANSACTION_ACCOUNTS WTA
                    ,PO_HEADERS_ALL           PHA
                    ,PO_LINES_ALL             PLA
                    ,ORG_ACCT_PERIODS_V       OPV
               WHERE WT.TRANSACTION_ID = WTA.TRANSACTION_ID
                 AND WT.PO_HEADER_ID = PHA.PO_HEADER_ID
                 AND WT.PO_LINE_ID = PLA.PO_LINE_ID
                 AND OPV.ORGANIZATION_ID = WT.ORGANIZATION_ID
                 AND OPV.ACCT_PERIOD_ID = WT.ACCT_PERIOD_ID
                 AND WT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                     OPV.END_DATE + 0.99999
                 AND OPV.REC_TYPE = 'ORG_PERIOD'
                 AND WTA.ACCOUNTING_LINE_TYPE = 7 --WIP 估价
                 AND WT.TRANSACTION_TYPE = 3 --外协加工     
                 AND WT.ORGANIZATION_ID = P_ORGANIZATION_ID
                 AND OPV.PERIOD_NAME = P_PERIOD_NAME_T
               GROUP BY OPV.PERIOD_NAME
                       ,PHA.VENDOR_SITE_ID
                       ,WT.ORGANIZATION_ID
                       ,PLA.ITEM_ID
                        --   ,WT.RESOURCE_ID
                       ,WT.TRANSACTION_UOM
                       ,WT.CURRENCY_CODE) B
            ,MTL_SYSTEM_ITEMS_B MSI
            ,FND_LOOKUP_VALUES_VL FLV
             --  ,CST_RESOURCE_COSTS CRC
            ,PO_VENDOR_SITES_ALL PVSA
       WHERE A.VENDOR_SITE_ID = B.VENDOR_SITE_ID(+)
         AND A.ITEM_ID = B.ITEM_ID(+)
         AND A.TRANSACTION_UOM = B.TRANSACTION_UOM(+)
         AND A.CURRENCY_CODE = B.CURRENCY_CODE(+)
         AND A.ITEM_ID = MSI.INVENTORY_ITEM_ID
         AND A.ORGANIZATION_ID = MSI.ORGANIZATION_ID
         AND MSI.ITEM_TYPE = FLV.LOOKUP_CODE
         AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
            -- AND A.RESOURCE_ID = CRC.RESOURCE_ID
            -- AND A.ORGANIZATION_ID = CRC.ORGANIZATION_ID
            -- AND CRC.COST_TYPE_ID = 1 --Frozen
         AND A.VENDOR_SITE_ID = PVSA.VENDOR_SITE_ID)
     
      UNION
     
       (SELECT A.PERIOD_NAME
              ,C.SEGMENT1 ITEM_NUMBER
              ,C.DESCRIPTION ITEM_DESC
              ,FLV.MEANING ITEM_TYPE --用户物料类型
              ,APPS.MEW_ITEM_GROUP_F(A.ORGANIZATION_ID
                                    ,A.INVENTORY_ITEM_ID
                                    ,'MEW_ACCT'
                                    ,2) ITEM_AUX --部品分类      
              ,A.CURRENCY_CODE --原币币种
              ,A.TRANSACTION_UOM --事务处理单位       
              ,PVSA.VENDOR_SITE_CODE --供应商地点
              ,CIC.ITEM_COST --标准单价
              ,A.TOTAL_TRANSACTION_QUANTITY
              ,A.TOTAL_TRANSACTION_VALUE
              ,A.TOTAL_BASE_TRANSACTION_VALUE
              ,B.TOTAL_TRANSACTION_QUANTITY TOTAL_TRANSACTION_QUANTITY_E
              ,B.TOTAL_TRANSACTION_VALUE TOTAL_TRANSACTION_VALUE_E
              ,B.TOTAL_BASE_TRANSACTION_VALUE TOTAL_BASE_TRANSACTION_VALUE_E
          FROM (SELECT OPV.PERIOD_NAME
                      ,PHA.VENDOR_SITE_ID
                      ,MMT.ORGANIZATION_ID
                      ,MMT.INVENTORY_ITEM_ID
                      ,MMT.TRANSACTION_UOM --事务处理单位
                      ,MMT.CURRENCY_CODE --原币币种
                      ,SUM(MMT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                      ,-SUM(MTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE --原币金额
                      ,-SUM(MTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE --本币金额
                  FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
                      ,APPS.PO_HEADERS_ALL            PHA
                      ,APPS.ORG_ACCT_PERIODS_V        OPV
                      ,APPS.MTL_TRANSACTION_ACCOUNTS  MTA
                 WHERE MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
                   AND MTA.ACCOUNTING_LINE_TYPE = 5
                   AND MMT.ORGANIZATION_ID = P_ORGANIZATION_ID
                   AND MMT.TRANSACTION_TYPE_ID IN (18
                                                  ,36) --PO RECEIPT OR RETURN TO VENDOR
                   AND MMT.TRANSACTION_QUANTITY <> 0
                   AND MMT.TRANSACTION_SOURCE_ID = PHA.PO_HEADER_ID
                   AND MMT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                       OPV.END_DATE + 0.99999
                   AND MMT.ORGANIZATION_ID = OPV.ORGANIZATION_ID
                   AND OPV.PERIOD_NAME = P_PERIOD_NAME_F
                   AND OPV.REC_TYPE = 'ORG_PERIOD'
                 GROUP BY OPV.PERIOD_NAME
                         ,PHA.VENDOR_SITE_ID
                         ,MMT.ORGANIZATION_ID
                         ,MMT.INVENTORY_ITEM_ID
                         ,MMT.TRANSACTION_UOM
                         ,MMT.CURRENCY_CODE) A
              ,(SELECT OPV.PERIOD_NAME
                      ,PHA.VENDOR_SITE_ID
                      ,MMT.ORGANIZATION_ID
                      ,MMT.INVENTORY_ITEM_ID
                      ,MMT.TRANSACTION_UOM --事务处理单位
                      ,MMT.CURRENCY_CODE --原币币种
                      ,SUM(MMT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                      ,-SUM(MTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE --原币金额
                      ,-SUM(MTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE --本币金额
                  FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
                      ,APPS.PO_HEADERS_ALL            PHA
                      ,APPS.ORG_ACCT_PERIODS_V        OPV
                      ,APPS.MTL_TRANSACTION_ACCOUNTS  MTA
                 WHERE MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
                   AND MTA.ACCOUNTING_LINE_TYPE = 5
                   AND MMT.ORGANIZATION_ID = P_ORGANIZATION_ID
                   AND MMT.TRANSACTION_TYPE_ID IN (18
                                                  ,36) --PO RECEIPT OR RETURN TO VENDOR
                   AND MMT.TRANSACTION_QUANTITY <> 0
                   AND MMT.TRANSACTION_SOURCE_ID = PHA.PO_HEADER_ID
                   AND MMT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                       OPV.END_DATE + 0.99999
                   AND MMT.ORGANIZATION_ID = OPV.ORGANIZATION_ID
                   AND OPV.PERIOD_NAME = P_PERIOD_NAME_T
                   AND OPV.REC_TYPE = 'ORG_PERIOD'
                 GROUP BY OPV.PERIOD_NAME
                         ,PHA.VENDOR_SITE_ID
                         ,MMT.ORGANIZATION_ID
                         ,MMT.INVENTORY_ITEM_ID
                         ,MMT.TRANSACTION_UOM
                         ,MMT.CURRENCY_CODE) B
              ,MTL_SYSTEM_ITEMS_B C
              ,APPS.FND_LOOKUP_VALUES_VL FLV
              ,APPS.PO_VENDOR_SITES_ALL PVSA
              ,APPS.CST_ITEM_COSTS CIC
         WHERE A.VENDOR_SITE_ID(+) = B.VENDOR_SITE_ID
           AND A.INVENTORY_ITEM_ID(+) = B.INVENTORY_ITEM_ID
           AND A.TRANSACTION_UOM(+) = B.TRANSACTION_UOM
           AND A.CURRENCY_CODE(+) = B.CURRENCY_CODE
           AND B.ORGANIZATION_ID = C.ORGANIZATION_ID
           AND B.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
           AND B.VENDOR_SITE_ID = PVSA.VENDOR_SITE_ID
           AND C.ITEM_TYPE = FLV.LOOKUP_CODE
           AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
           AND B.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID(+)
           AND B.ORGANIZATION_ID = CIC.ORGANIZATION_ID(+)
           AND CIC.COST_TYPE_ID(+) = 1 --Frozen
       
        UNION ALL
       
        SELECT A.PERIOD_NAME
              ,MSI.SEGMENT1 ITEM_NUMBER
              ,MSI.DESCRIPTION ITEM_DESC
              ,FLV.MEANING ITEM_TYPE --用户物料类型
              ,MEW_ITEM_GROUP_F(MSI.ORGANIZATION_ID
                               ,MSI.INVENTORY_ITEM_ID
                               ,'MEW_ACCT'
                               ,2) ITEM_AUX --部品分类
              ,A.CURRENCY_CODE
              ,A.TRANSACTION_UOM
              
              ,PVSA.VENDOR_SITE_CODE
              ,(SELECT MAX(CRCC.RESOURCE_RATE)
                  FROM BOM_RESOURCES      BRV
                      ,CST_RESOURCE_COSTS CRCC
                 WHERE BRV.ORGANIZATION_ID = B.ORGANIZATION_ID
                   AND BRV.COST_CODE_TYPE IN (3
                                             ,4)
                   AND CRCC.COST_TYPE_ID = 1
                   AND (BRV.PURCHASE_ITEM_ID = B.ITEM_ID)
                   AND BRV.RESOURCE_ID = CRCC.RESOURCE_ID
                   AND BRV.ORGANIZATION_ID = CRCC.ORGANIZATION_ID) ITEM_COST
               --  ,CRC.RESOURCE_RATE     ITEM_COST
              
              ,A.TOTAL_TRANSACTION_QUANTITY
              ,A.TOTAL_TRANSACTION_VALUE
              ,A.TOTAL_BASE_TRANSACTION_VALUE
              ,B.TOTAL_TRANSACTION_QUANTITY   TOTAL_TRANSACTION_QUANTITY_E
              ,B.TOTAL_TRANSACTION_VALUE      TOTAL_TRANSACTION_VALUE_E
              ,B.TOTAL_BASE_TRANSACTION_VALUE TOTAL_BASE_TRANSACTION_VALUE_E
          FROM (SELECT OPV.PERIOD_NAME
                      ,PHA.VENDOR_SITE_ID
                      ,WT.ORGANIZATION_ID
                      ,PLA.ITEM_ID
                       -- ,WT.RESOURCE_ID
                      ,WT.TRANSACTION_UOM
                      ,WT.CURRENCY_CODE
                      ,SUM(WT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                      ,SUM(WTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE
                      ,SUM(WTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE
                  FROM WIP_TRANSACTIONS         WT
                      ,WIP_TRANSACTION_ACCOUNTS WTA
                      ,PO_HEADERS_ALL           PHA
                      ,PO_LINES_ALL             PLA
                      ,ORG_ACCT_PERIODS_V       OPV
                 WHERE WT.TRANSACTION_ID = WTA.TRANSACTION_ID
                   AND WT.PO_HEADER_ID = PHA.PO_HEADER_ID
                   AND WT.PO_LINE_ID = PLA.PO_LINE_ID
                   AND OPV.ORGANIZATION_ID = WT.ORGANIZATION_ID
                   AND OPV.ACCT_PERIOD_ID = WT.ACCT_PERIOD_ID
                   AND WT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                       OPV.END_DATE + 0.99999
                   AND OPV.REC_TYPE = 'ORG_PERIOD'
                   AND WTA.ACCOUNTING_LINE_TYPE = 7 --WIP 估价
                   AND WT.TRANSACTION_TYPE = 3 --外协加工     
                   AND WT.ORGANIZATION_ID = P_ORGANIZATION_ID
                   AND OPV.PERIOD_NAME = P_PERIOD_NAME_F
                 GROUP BY OPV.PERIOD_NAME
                         ,PHA.VENDOR_SITE_ID
                         ,WT.ORGANIZATION_ID
                         ,PLA.ITEM_ID
                          --  ,WT.RESOURCE_ID
                         ,WT.TRANSACTION_UOM
                         ,WT.CURRENCY_CODE) A
              ,(SELECT OPV.PERIOD_NAME
                      ,PHA.VENDOR_SITE_ID
                      ,WT.ORGANIZATION_ID
                      ,PLA.ITEM_ID
                       -- ,WT.RESOURCE_ID
                      ,WT.TRANSACTION_UOM
                      ,WT.CURRENCY_CODE
                      ,SUM(WT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
                      ,SUM(WTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE
                      ,SUM(WTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE
                  FROM WIP_TRANSACTIONS         WT
                      ,WIP_TRANSACTION_ACCOUNTS WTA
                      ,PO_HEADERS_ALL           PHA
                      ,PO_LINES_ALL             PLA
                      ,ORG_ACCT_PERIODS_V       OPV
                 WHERE WT.TRANSACTION_ID = WTA.TRANSACTION_ID
                   AND WT.PO_HEADER_ID = PHA.PO_HEADER_ID
                   AND WT.PO_LINE_ID = PLA.PO_LINE_ID
                   AND OPV.ORGANIZATION_ID = WT.ORGANIZATION_ID
                   AND OPV.ACCT_PERIOD_ID = WT.ACCT_PERIOD_ID
                   AND WT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
                       OPV.END_DATE + 0.99999
                   AND OPV.REC_TYPE = 'ORG_PERIOD'
                   AND WTA.ACCOUNTING_LINE_TYPE = 7 --WIP 估价
                   AND WT.TRANSACTION_TYPE = 3 --外协加工     
                   AND WT.ORGANIZATION_ID = P_ORGANIZATION_ID
                   AND OPV.PERIOD_NAME = P_PERIOD_NAME_T
                 GROUP BY OPV.PERIOD_NAME
                         ,PHA.VENDOR_SITE_ID
                         ,WT.ORGANIZATION_ID
                         ,PLA.ITEM_ID
                          -- ,WT.RESOURCE_ID
                          --  ,WT.RESOURCE_ID
                         ,WT.TRANSACTION_UOM
                         ,WT.CURRENCY_CODE) B
              ,MTL_SYSTEM_ITEMS_B MSI
              ,FND_LOOKUP_VALUES_VL FLV
               -- ,CST_RESOURCE_COSTS CRC
              ,PO_VENDOR_SITES_ALL PVSA
         WHERE A.VENDOR_SITE_ID(+) = B.VENDOR_SITE_ID
           AND A.ITEM_ID(+) = B.ITEM_ID
           AND A.TRANSACTION_UOM(+) = B.TRANSACTION_UOM
           AND A.CURRENCY_CODE(+) = B.CURRENCY_CODE
           AND B.ITEM_ID = MSI.INVENTORY_ITEM_ID
           AND B.ORGANIZATION_ID = MSI.ORGANIZATION_ID
           AND MSI.ITEM_TYPE = FLV.LOOKUP_CODE
           AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
              --  AND B.RESOURCE_ID = CRC.RESOURCE_ID
              --   AND B.ORGANIZATION_ID = CRC.ORGANIZATION_ID
              -- AND CRC.COST_TYPE_ID = 1 --Frozen
           AND B.VENDOR_SITE_ID = PVSA.VENDOR_SITE_ID);
 
    CURSOR C2 IS
      SELECT 1 DATA_TYPE
            ,OPV.PERIOD_NAME
            ,MSI.SEGMENT1 ITEM_NUMBER --品号
            ,MSI.DESCRIPTION ITEM_DESC --品名
            ,FLV.MEANING ITEM_TYPE --用户物料类型
            ,MMT.TRANSACTION_UOM --事务处理单位
            ,APPS.MEW_ITEM_GROUP_F(MMT.ORGANIZATION_ID
                                  ,MMT.INVENTORY_ITEM_ID
                                  ,'MEW_ACCT'
                                  ,2) ITEM_AUX --部品分类
            ,PVSA.VENDOR_SITE_CODE --供应商地点
            ,CIC.ITEM_COST --标准单价
            ,MMT.CURRENCY_CODE --原币币种
            ,SUM(MMT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
            ,-SUM(MTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE --原币金额
            ,-SUM(MTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE --本币金额
        FROM APPS.MTL_MATERIAL_TRANSACTIONS MMT
            ,APPS.MTL_SYSTEM_ITEMS_B        MSI
            ,APPS.FND_LOOKUP_VALUES_VL      FLV
            ,APPS.PO_HEADERS_ALL            PHA
            ,APPS.PO_VENDOR_SITES_ALL       PVSA
            ,APPS.CST_ITEM_COSTS            CIC
            ,APPS.ORG_ACCT_PERIODS_V        OPV
            ,APPS.MTL_TRANSACTION_ACCOUNTS  MTA
       WHERE MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
         AND MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
         AND MSI.ITEM_TYPE = FLV.LOOKUP_CODE
         AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
         AND MMT.TRANSACTION_SOURCE_ID = PHA.PO_HEADER_ID
         AND PHA.VENDOR_SITE_ID = PVSA.VENDOR_SITE_ID
         AND MMT.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
         AND MMT.ORGANIZATION_ID = CIC.ORGANIZATION_ID
         AND CIC.COST_TYPE_ID = 1 --Frozen
         AND MMT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
             OPV.END_DATE + 0.99999
         AND MMT.ORGANIZATION_ID = OPV.ORGANIZATION_ID
         AND OPV.PERIOD_NAME = P_PERIOD_NAME_F
         AND OPV.REC_TYPE = 'ORG_PERIOD'
         AND MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
         AND MTA.ACCOUNTING_LINE_TYPE = 5
         AND MMT.ORGANIZATION_ID = P_ORGANIZATION_ID
         AND MMT.TRANSACTION_TYPE_ID = 18
         AND MMT.TRANSACTION_QUANTITY <> 0
       GROUP BY OPV.PERIOD_NAME
               ,MSI.SEGMENT1
               ,MSI.DESCRIPTION
               ,FLV.MEANING
               ,MMT.TRANSACTION_UOM --事务处理单位
               ,APPS.MEW_ITEM_GROUP_F(MMT.ORGANIZATION_ID
                                     ,MMT.INVENTORY_ITEM_ID
                                     ,'MEW_ACCT'
                                     ,2)
               ,PVSA.VENDOR_SITE_CODE --供应商地点
               ,CIC.ITEM_COST --标准单价
               ,MMT.CURRENCY_CODE --原币币种
     
      UNION ALL
     
      SELECT 2 DATA_TYPE
            ,OPV.PERIOD_NAME
            ,MSI.SEGMENT1 ITEM_NUMBER
            ,MSI.DESCRIPTION ITEM_DESC
            ,FLV.MEANING ITEM_TYPE --用户物料类型
            ,WT.TRANSACTION_UOM
            ,MEW_ITEM_GROUP_F(PLA.ORG_ID
                             ,PLA.ITEM_ID
                             ,'MEW_ACCT'
                             ,2) ITEM_AUX --部品分类
            ,PVSA.VENDOR_SITE_CODE
            ,CRC.RESOURCE_RATE ITEM_COST
            ,WT.CURRENCY_CODE
            ,SUM(WT.TRANSACTION_QUANTITY) TOTAL_TRANSACTION_QUANTITY
            ,SUM(WTA.TRANSACTION_VALUE) TOTAL_TRANSACTION_VALUE
            ,SUM(WTA.BASE_TRANSACTION_VALUE) TOTAL_BASE_TRANSACTION_VALUE
        FROM WIP_TRANSACTIONS         WT
            ,WIP_TRANSACTION_ACCOUNTS WTA
            ,PO_HEADERS_ALL           PHA
            ,PO_LINES_ALL             PLA
            ,PO_VENDOR_SITES_ALL      PVSA
            ,MTL_SYSTEM_ITEMS_B       MSI
            ,FND_LOOKUP_VALUES_VL     FLV
            ,ORG_ACCT_PERIODS_V       OPV
            ,CST_RESOURCE_COSTS       CRC
       WHERE WT.TRANSACTION_ID = WTA.TRANSACTION_ID
         AND WT.PO_HEADER_ID = PHA.PO_HEADER_ID
         AND PHA.VENDOR_SITE_ID = PVSA.VENDOR_SITE_ID
         AND WT.PO_LINE_ID = PLA.PO_LINE_ID
         AND PLA.ITEM_ID = MSI.INVENTORY_ITEM_ID
         AND WT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
         AND MSI.ITEM_TYPE = FLV.LOOKUP_CODE
         AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
         AND OPV.ORGANIZATION_ID = WT.ORGANIZATION_ID
         AND OPV.ACCT_PERIOD_ID = WT.ACCT_PERIOD_ID
         AND WT.TRANSACTION_DATE BETWEEN OPV.START_DATE AND
             OPV.END_DATE + 0.99999
         AND OPV.REC_TYPE = 'ORG_PERIOD'
         AND WTA.ACCOUNTING_LINE_TYPE = 7 --WIP 估价
         AND WT.TRANSACTION_TYPE = 3 --外协加工
         AND WT.RESOURCE_ID = CRC.RESOURCE_ID
         AND WT.ORGANIZATION_ID = CRC.ORGANIZATION_ID
         AND CRC.COST_TYPE_ID = 1 --Frozen           
         AND WT.ORGANIZATION_ID = P_ORGANIZATION_ID
         AND OPV.PERIOD_NAME = P_PERIOD_NAME_F
       GROUP BY OPV.PERIOD_NAME
               ,MSI.SEGMENT1
               ,MSI.DESCRIPTION
               ,FLV.MEANING
               ,WT.TRANSACTION_UOM
               ,MEW_ITEM_GROUP_F(PLA.ORG_ID
                                ,PLA.ITEM_ID
                                ,'MEW_ACCT'
                                ,2)
               ,PVSA.VENDOR_SITE_CODE
               ,CRC.RESOURCE_RATE
               ,WT.CURRENCY_CODE;
    V_SEP                          VARCHAR2(10);
    V_LINE_STR                     VARCHAR2(4000);
    V_TOTAL_TRANSACTION_QUANTITY   NUMBER := 0;
    V_TOTAL_TRANSACTION_VALUE      NUMBER := 0;
    V_TOTAL_BASE_TRANSACTION_VALUE NUMBER := 0;
    V_PRICE_VARIANCE               NUMBER := 0;
    V_RATE_VARIANCE                NUMBER := 0;
    V_AMOUNT_VARIANCE_CNY_A        NUMBER := 0;
    V_AMOUNT_VARIANCE_CNY_B        NUMBER := 0;
    V_AMOUNT_VARIANCE_CNY_T        NUMBER := 0;
    V_AMOUNT_VARIANCE_CNY_AT       NUMBER := 0;
    V_AMOUNT_VARIANCE_CNY_BT       NUMBER := 0;
    V_AMOUNT_VARIANCE_CNY_TT       NUMBER := 0;
    V_PRICE_F                      NUMBER := 0;
    V_PRICE_T                      NUMBER := 0;
    V_RATE_T                       NUMBER := 0;
    V_RATE_F                       NUMBER := 0;
  BEGIN
    --表示以文件形式进行输出，在开发HTML报表时，固定即可，不需修改
    HTML_REPORT_PKG.V_REPORT_OUTPUT_MODE := 'F';
    --为输出字符串的分隔符号赋值，分隔符号的值，在输出字段的值中不能包含，否则，会造成分隔错误。
    V_SEP := '@';
    --在HTML报表上输出导出EXCEL按钮
    HTML_REPORT_PKG.OUTPUT_LINE('<SCRIPT LANGUAGE="javascript">
       function method1(tableid) {
             var curTbl = document.getElementById(tableid);
                 var oXL = new ActiveXObject("Excel.Application");
                 var oWB = oXL.Workbooks.Add();
                 var oSheet = oWB.ActiveSheet;
                 var sel = document.body.createTextRange();
                 sel.moveToElementText(curTbl);
                 sel.select();
                 sel.execCommand("Copy");
                 oSheet.Paste();
                 oXL.Visible = true;
             }
       </script> <input type="submit" οnclick=method1("execl")  value="导出到EXCEL"/>');
    --输出标题
    HTML_REPORT_PKG.HTML_TITLE(P_PROGRAM_TITLE => '报表'
                              ,P_REPORT_TITLE  => 'PEWWBBG材料采购价格对比表');
    --输出参数值
    HTML_REPORT_PKG.OUTPUT_LINE('打印时间：' ||
                                TO_CHAR(SYSDATE
                                       ,'yyyy-mm-dd hh24:mi'));
    HTML_REPORT_PKG.OUTPUT_LINE('<BR>Organization Code：' ||
                                P_ORGANIZATION_ID);
    HTML_REPORT_PKG.OUTPUT_LINE('<BR>基期：' || P_PERIOD_NAME_F);
    HTML_REPORT_PKG.OUTPUT_LINE('<BR>当期：' || P_PERIOD_NAME_T);
    --开始进行内容的输出，下行的width=1200，用于进行输出表格的宽度设置
    --HTML导成EXCEL功能代码
    HTML_REPORT_PKG.OUTPUT_LINE('<table width=150% style="border-collapse:collapse; border:none; font-family: 宋体; font-size: 10pt" border=1 bordercolor=#000000 cellspacing="0"id="execl" name="execl" >');
    --将表格标题，用逗号分隔后，连接成一个字符串，注意：最后一个字段之后，也要有个逗号。
    FND_FILE.PUT_LINE(FND_FILE.OUTPUT
                     , '<tr>
<td  rowspan="2" >品号</td>
<td  rowspan="2" >品名</td>
<td  rowspan="2" >采购类型</td>
<td  rowspan="2" >单位</td>
<td  rowspan="2" >部品种类</td>
<td  rowspan="2" >供应商地点</td>
<td  rowspan="2" >标准单价</td>
<td  rowspan="2" >币种</td>
<td  colspan="4" align="center" >' || P_PERIOD_NAME_F ||
                       '</td>
<td  colspan="4" align="center">' || P_PERIOD_NAME_T ||
                       '</td>
<td  colspan="5"  align="center">' || '差异额' || '</td>              
</tr>');
    FND_FILE.PUT_LINE(FND_FILE.OUTPUT
                     , '<tr>
<td>' || '数量' || '</td>
<td>' || '汇率' || '</td>
<td>' || '单价(原币)' || '</td>
<td>' || '金额(人民币)' || '</td>
<td>' || '数量' || '</td>
<td>' || '汇率' || '</td>
<td>' || '单价(原币)' || '</td>
<td>' || '金额(人民币)' || '</td>   

<td>' || '价格差I' || '</td>
<td>' || '金额差A(人民币)' || '</td>
<td>' || '汇率差II' || '</td>
<td>' || '金额差B(人民币)' || '</td>
<td>' || '金额差合计C' || '</td>          
</tr>');
    --基期
    FOR R1 IN C1
    LOOP
   
      --当期价格
      IF NVL(R1.TOTAL_TRANSACTION_QUANTITY_E
            ,0) = 0
      THEN
        V_PRICE_T := 0;
      ELSE
        V_PRICE_T := NVL(ROUND(NVL(R1.TOTAL_TRANSACTION_VALUE_E
                                  ,R1.TOTAL_BASE_TRANSACTION_VALUE_E) /
                               R1.TOTAL_TRANSACTION_QUANTITY_E
                              ,6) --当期价格
                        ,0);
      END IF;
   
      --基期价格
      IF /*R1.TOTAL_TRANSACTION_VALUE_E = 0 OR*/
       NVL(R1.TOTAL_TRANSACTION_QUANTITY
          ,0) = 0
      THEN
        V_PRICE_F := 0;
      ELSE
        V_PRICE_F := NVL(ROUND(NVL(R1.TOTAL_TRANSACTION_VALUE
                                  ,R1.TOTAL_BASE_TRANSACTION_VALUE) /
                               R1.TOTAL_TRANSACTION_QUANTITY
                              ,6) --当期价格
                        ,0);
      END IF;
   
      --价格差   
      V_PRICE_VARIANCE := V_PRICE_T - V_PRICE_F; --当期价格-基期价格
   
      --基期汇率
      IF NVL(NVL(R1.TOTAL_TRANSACTION_VALUE
                ,R1.TOTAL_BASE_TRANSACTION_VALUE)
            ,0) = 0
      THEN
        V_RATE_F := 0;
      ELSE
        V_RATE_F := ROUND(NVL(R1.TOTAL_BASE_TRANSACTION_VALUE
                             ,0) /
                          NVL(R1.TOTAL_TRANSACTION_VALUE
                             ,R1.TOTAL_BASE_TRANSACTION_VALUE)
                         ,6);
      END IF;
   
      --金额差（人民币）A
      BEGIN
        V_AMOUNT_VARIANCE_CNY_A := NVL(V_PRICE_VARIANCE *
                                       R1.TOTAL_TRANSACTION_QUANTITY_E *
                                       V_RATE_F
                                      ,0);
      EXCEPTION
        WHEN OTHERS THEN
          V_AMOUNT_VARIANCE_CNY_A := 0;
      END;
   
      --当期汇率
      IF NVL(NVL(R1.TOTAL_TRANSACTION_VALUE_E --原币金额
                ,R1.TOTAL_BASE_TRANSACTION_VALUE_E) --本币金额
            ,0) = 0
      THEN
        V_RATE_T := 0;
      ELSE
        V_RATE_T := NVL(ROUND(R1.TOTAL_BASE_TRANSACTION_VALUE_E /
                              NVL(R1.TOTAL_TRANSACTION_VALUE_E
                                 ,R1.TOTAL_BASE_TRANSACTION_VALUE_E)
                             
                             ,6)
                       ,0);
      END IF;
   
      --汇率差     
      V_RATE_VARIANCE := V_RATE_T - V_RATE_F; --当期汇率-基期汇率
   
      --金额差（人民币）B
      V_AMOUNT_VARIANCE_CNY_B := V_RATE_VARIANCE * V_PRICE_T *
                                 NVL(R1.TOTAL_TRANSACTION_QUANTITY_E
                                    ,0);
   
      --金额差合计A+B
      V_AMOUNT_VARIANCE_CNY_T := V_AMOUNT_VARIANCE_CNY_A +
                                 V_AMOUNT_VARIANCE_CNY_B;
   
      HTML_REPORT_PKG.LINE_TITLE(P_TITLE_STRING    => R1.ITEM_NUMBER ||
                                                      V_SEP || R1.ITEM_DESC ||
                                                      V_SEP || R1.ITEM_TYPE ||
                                                      V_SEP ||
                                                      R1.TRANSACTION_UOM ||
                                                      V_SEP || R1.ITEM_AUX ||
                                                      V_SEP ||
                                                      R1.VENDOR_SITE_CODE ||
                                                      V_SEP ||
                                                      ROUND(R1.ITEM_COST
                                                           ,6) || V_SEP ||
                                                      R1.CURRENCY_CODE ||
                                                      V_SEP ||
                                                     --基期 数量 汇率 单价(原币) 金额(人民币)
                                                      R1.TOTAL_TRANSACTION_QUANTITY ||
                                                      V_SEP || V_RATE_F ||
                                                      V_SEP || V_PRICE_F ||
                                                      V_SEP ||
                                                      R1.TOTAL_BASE_TRANSACTION_VALUE ||
                                                     --当期 数量 汇率 单价(原币) 金额(人民币)
                                                      V_SEP ||
                                                      NVL(R1.TOTAL_TRANSACTION_QUANTITY_E
                                                         ,0) || V_SEP ||
                                                      V_RATE_T || V_SEP ||
                                                      V_PRICE_T || V_SEP ||
                                                      NVL(R1.TOTAL_BASE_TRANSACTION_VALUE_E
                                                         ,0) || V_SEP ||
                                                      V_PRICE_VARIANCE ||
                                                      V_SEP ||
                                                      V_AMOUNT_VARIANCE_CNY_A ||
                                                      V_SEP ||
                                                      V_RATE_VARIANCE ||
                                                      V_SEP ||
                                                      V_AMOUNT_VARIANCE_CNY_B ||
                                                      V_SEP ||
                                                      V_AMOUNT_VARIANCE_CNY_T ||
                                                      V_SEP
                                ,P_WITH_OTHER_ATTR => 'Y'
                                ,P_ATTR_DELIMITER  => '***'
                                ,P_DELIMITER       => V_SEP);
   
      V_AMOUNT_VARIANCE_CNY_AT := V_AMOUNT_VARIANCE_CNY_AT +
                                  V_AMOUNT_VARIANCE_CNY_A;
      V_AMOUNT_VARIANCE_CNY_BT := V_AMOUNT_VARIANCE_CNY_BT +
                                  V_AMOUNT_VARIANCE_CNY_B;
      V_AMOUNT_VARIANCE_CNY_TT := V_AMOUNT_VARIANCE_CNY_TT +
                                  V_AMOUNT_VARIANCE_CNY_T;
   
      V_TOTAL_TRANSACTION_QUANTITY   := 0;
      V_TOTAL_TRANSACTION_VALUE      := 0;
      V_TOTAL_BASE_TRANSACTION_VALUE := 0;
      V_PRICE_VARIANCE               := 0;
      V_AMOUNT_VARIANCE_CNY_A        := 0;
      V_RATE_VARIANCE                := 0;
      V_AMOUNT_VARIANCE_CNY_B        := 0;
      V_AMOUNT_VARIANCE_CNY_T        := 0;
      V_PRICE_F                      := 0;
      V_PRICE_T                      := 0;
      V_RATE_F                       := 0;
      V_RATE_T                       := 0;
    END LOOP;
 
    HTML_REPORT_PKG.LINE_TITLE(P_TITLE_STRING    => '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '' || V_SEP || '' ||
                                                    V_SEP || '合计：' || V_SEP ||
                                                    V_AMOUNT_VARIANCE_CNY_AT ||
                                                    V_SEP || '' || V_SEP ||
                                                    V_AMOUNT_VARIANCE_CNY_BT ||
                                                    V_SEP ||
                                                    V_AMOUNT_VARIANCE_CNY_TT ||
                                                    V_SEP
                              ,P_WITH_OTHER_ATTR => 'Y'
                              ,P_ATTR_DELIMITER  => '***'
                              ,P_DELIMITER       => V_SEP);
    --输出表格和网页结束时的标签符
    HTML_REPORT_PKG.OUTPUT_LINE('</tr></table></html>');
  END;

END;
/

QQ51567242
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
HTML报表通用模版
储藏室
07-24 1万+
create or replace package HTML_REPORT_PKG is ------------------------------------------------------------------- --                    生成HTML格式报表的程序包                    - --                       张
html5-demo报表挺全挺不错
11-07
html5-demo报表挺全挺不错html5报表开发必备资源 值得学习借鉴
html5纯代码报表工具实例
02-27
html5纯代码报表工具实例 这两天用html5做了一个简单的报表工具，调用调用起来非常简单（如果有时间的话，最好看看html的源码）（注释很清晰）。 （由于html5里边的canvas的原因，报表效果只能在Ie9或者是谷歌浏览器里边显示出来） 以下是一些调用的函数： drawCake（myList,x,y,r）是画饼图 (数组格式的数据源，x坐标，y坐标，半径) drawRadar（myList,x,y,width,height）是画雷达图 (数组格式的数据源，x坐标，y坐标，高度，宽度) drawBrokenLine （myList,x,y,width,height） 是画折线图 (数组格式的数据源，x坐标，y坐标，高度，宽度) drawHistogram （myList,x,y,width,height） 是画柱状图 (数组格式的数据源，x坐标，y坐标，高度，宽度)
HTML_表格实例
Twilight's Blog
01-01 1万+
html表格的几种形式
Html报表示例，WebBrowser打印
06-29
Html报表例子源码，使用webbrowser控件在窗口中显示htm文档
iReport 4.0.1 + JasperReport 导出Html和PDF报表例子源码
07-17
iReport 4.0.1 导出Html和PDF报表完整例子
Grid++Report 6.6.7.0 Demo模板例子 免费报表开发工具
06-03
Web报表例子程序包括：asp.net(c#)、asp.net(vb)、php、jsp。还有可直接运行的例子应用程序。 帮助文档及其它有关Grid++Report的文档与资源。 5. 请根据帮助文档中的相关说明，首先把例子程序运行起来。请尽量...
最好用免费报表开发工具Grid++Report 6.7.5.1 (6.7.20.405) 含演示Demo例子模板
04-17
Grid++Report是一款同时支持C/S软件(桌面程序)与B/S软件(WEB程序)开发的报表工具，功能全面易学易用。...1. 含C/S报表组件、WEB报表插件、HTML5报表与WEB报表服务器开发的相关文件。 2. Grid++Report多语言集成支持
VB.Net2005水晶报表筛选数据例子
02-26
帮网友做的，水晶报表筛选数据例子。 网友提问：（有运行结果界面） http://topic.csdn.net/u/20110118/23/8a7d2b06-34b6-4881-b9ca-97d8310d13f1.html
js导出html表格中数据示例
03-25
js导出html数据存入excel中,存在兼容问题支持部分浏览器
html table 示例,HTML表格实例
weixin_33533797的博客
06-05 960
表格实例每个表格由 table 标签开始。每个表格行由 tr 标签开始。每个表格数据和英文由 td 标签开始。每个表格汉子由 th 标签开始。这是一个段落。这是另一个段落。这个单元包含一个表格：三行三列:思思的表格姓名电话2112你好31这个单元包含一个列表：11香蕉菠萝HELLO运行结果WechatIMG101.pngWechatIMG100.png单元格边距、间距、背景颜色、排列没有 cel...
html 做报表,创建 HTML 报表
weixin_29577845的博客
06-19 1924
创建 HTML 报表HTML 报表可包含许多 HTML和图像文件。它们作为 .zip 文件被传输至用户。本教程展示如何：创建 HTML在 HTML 报表中嵌入图像添加层级以标签形式添加层级变量标签所得报表对于三年的每一年都有相应的标题和图像。HTML 报表支持大多数 Qlik Sense 对象。请参阅： 使用 Qlik 对象测试您可使用我们的示例文件来创建自己的报表。要下载这些文件，请参阅：示例...
Actionsheet操作菜单 手机上拉菜单
默默地博客
05-13 616
<style> .ui-actionsheet { position: fixed; z-index: 9999; top: 0; left: 0; display: -webkit-box; width: 100%; height: 100%; pointer-events: none;.
html5自定义报表工具,利用javascript和jxl实现自定义报表的输出
weixin_42497633的博客
06-18 559
因为之前有项目需要做大量报表，编写报表，花费大量时间，为了减少时间，所以研究下自定义报表实现方式。在很多报表工具，它们实现自定义报表的方式：基本都是数据集和数据显示格式这部分提取出来，实现自定义。本文也主要是数据集和数据显示格式两部分的自定义，选用技术：利用javascript定义数据集，jxl定义报表的格式。在jdk6开始，java可以执行javascript脚本语言了，而jxl可以先定义好模板...
html表单整理，实例
热门推荐
chen983234416的博客
11-16 1万+
    首先通过一个实例来表明表单的一些基本的使用，然后详细讲解表单里面的属性，最后再做出总结。   接下来解析上面的例子  1、表单的作用：用来搜集不同类型的用户输入 2、&lt;form action="#" method="get"&gt; &lt;/form&gt; : form标签表示表单。action="#"：设置数据的提交地址，就是提交给 哪一个页面。method="get...
[html]表格实例
qq_37301470的博客
11-06 520
[html]表格实例 一：没有边框的表格（border=0） <!DOCTYPE html> <html> <head> <title>表格</title> </head> <body> <table border="0"> <th>wtf</th> <tr> <td>100</td> <td>200</td&
nui 的 form表单提交（兼容ajax和表单submit）
myflok的专栏
09-20 3230
页面： 多个表单项 js: ajax:   var form = new nui.Form("form1");   var data = form.getData(true, false);   var json = nui.encode(data);   //序列化成JSON nui.ajax({                 url: "逻辑流或页面",  
EBS 多sheet页Excel动态报表开发过程
月下狼~图腾~
01-30 569
1.前言本文讲述的多Sheet页EXCEL报表开发方式和开发HTML,PDF这类报表的方法大致是一致的，唯一不同的是该报表输出是一个XML文件，但是这种XML文件支持EXCEL直接打开。这种方式有如下两点点非常明显的优点：（1） 灵活性。如果客户对报表显示样式要求非常严格的话，那用这种方式就非常方便了，就比如我这次项目的客户是个德国人，对报表的显示样式要求极为苛刻，甚至严格到每个列的颜色，边框...
html语言设计表单实例,Html表格制作及实例
weixin_35056641的博客
05-30 1414
简单标准表格：Html命令：第1行第1列第1行第2列第2行第1列第2行第2列31324142第1行第1列第1行第2列第2行第1列第2行第2列31324142上下合并的表格、并可加表格线颜色：Html命令：11122131321112213132左右合并的表格、并可加表格线颜色：Html命令：11 Merge2112313211 Merge21123132实例1：合并格111213212223313...
wkhtmltopdf怎么使用，有没有例子
最新发布
04-29
下面是一个使用wkhtmltopdf将HTML文件转换成PDF文件的例子： 1. 创建一个名为test.html的文件，输入以下内容： ```html <html> <title>HTML to PDF Example <h1>HTML to PDF Example <p>This is an ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值