eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FND_SIF_ACTIVE_DEFINITIONS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'