Oracle EBS Webservice（Integration Repository） Scripts

Webservice定义

SELECT   FF.TYPE ,

       FF.IREP_METHOD_NAME   ,

       FIF.FUNCTION_ID   ,

       FF.FUNCTION_NAME   ,

       FIC.CLASS_NAME   ,

       IREP_NAME   ,

       FIF.DESCRIPTION   ,

       FIC.   *

    FROM   FND_FORM_FUNCTIONS_VL     FF   ,

       FND_IREP_FUNCTION_FLAVORS FIF   ,

       FND_IREP_CLASSES          FIC

  WHERE   FIF.FUNCTION_ID   =   FF.FUNCTION_ID

     AND   FF.IREP_CLASS_ID   =   FIC.CLASS_ID

     --AND FIC.IREP_NAME = 'FA_ADJUSTMENT_PUB'

     AND   FF.FUNCTION_NAME   LIKE   '%FA_ADJUSTMENT_PUB%'   ;

Webservice参数查看

SELECT   IREP_NAME   ||   '.'   ||   FF.IREP_METHOD_NAME API   ,

       FP.PARAM_NAME   ,

       FP.PARAM_DIRECTION   ,

       FP.PARAM_OPTIONAL   ,

       FP.DEFAULT_VALUE   ,

       FP.PARAMETER_TYPE

    FROM   FND_FORM_FUNCTIONS_VL     FF   ,

       FND_IREP_FUNCTION_FLAVORS FIF   ,

       FND_IREP_CLASSES          FIC   ,

       FND_PARAMETERS            FP

  WHERE   FIF.FUNCTION_ID   =   FF.FUNCTION_ID

     AND   FF.IREP_CLASS_ID   =   FIC.CLASS_ID

     AND   FUNCTION_NAME   LIKE   '%FA_ADJUSTMENT_PUB%'

     AND   FP.FUNCTION_ID   =   FF.FUNCTION_ID

-- AND param_optional = 'N'

  ORDER   BY   1   ,   PARAM_SEQUENCE;