View: FND_SIF_ACTIVE_DEFINITIONS_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_SIF_ACTIVE_DEFINITIONS_V

View Text

SELECT FSD.DEFINITION_NAME
, FSD.DISPLAY_NAME
, FSD.DESCRIPTION
, FA.APPLICATION_SHORT_NAME
, FSD.STATUS
, FSD.SERVICE
, FSD.PORT
, FSD.OPERATION
, FSD.ATTR1 WSDL_URL
, FSD.WSDL_TNS TNS
, FSS.XSL_IN
, FSS.XSL_OUT
, FSS.CALLBACK_AGENT
, FSS.CALLBACK_EVENT
, FSA.ELEMENT_NAME
, FSA.ELEMENT_NS
, FSA.UNBOUNDED
, FSS.HANDLER_CLASS
, FSD.INTERACTION_TYPE
, FSS.JAXB_INPUT
, FSS.JAXB_OUTPUT
, FSS.ACTION
, FSS.ACTION_ATTRIBUTE FROM FND_SIF_DEFINITIONS_VL FSD INNER JOIN FND_APPLICATION FA ON FA.APPLICATION_ID = FSD.APPLICATION_ID LEFT OUTER JOIN FND_SIF_SETTINGS FSS ON FSS.DEFINITION_NAME = FSD.DEFINITION_NAME LEFT OUTER JOIN FND_SIF_ATTACHMENTS FSA ON FSA.DEFINITION_NAME = FSD.DEFINITION_NAME WHERE FSD.STATUS = 'E'