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.XDP_FE_SUMMARY_V

Source

View Text - Preformatted


SELECT XFE.fe_id fe_id , XFE.fulfillment_element_name fe_name , XAT.application_mode appl_mode, XAT.inbound_required_flag inbound_required_flag, XFE.display_name display_name , COUNT(XAR.fe_id) num_of_adapters FROM xdp_fes_vl XFE , xdp_adapter_reg XAR , xdp_adapter_types_b XAT WHERE XAR.adapter_type = XAT.adapter_type AND XFE.fe_id = XAR.fe_id GROUP BY XFE.fe_id , XAT.application_mode, XAT.inbound_required_flag, XFE.fulfillment_element_name , XFE.display_name

View Text - HTML Formatted

SELECT XFE.FE_ID FE_ID
, XFE.FULFILLMENT_ELEMENT_NAME FE_NAME
, XAT.APPLICATION_MODE APPL_MODE
, XAT.INBOUND_REQUIRED_FLAG INBOUND_REQUIRED_FLAG
, XFE.DISPLAY_NAME DISPLAY_NAME
, COUNT(XAR.FE_ID) NUM_OF_ADAPTERS
FROM XDP_FES_VL XFE
, XDP_ADAPTER_REG XAR
, XDP_ADAPTER_TYPES_B XAT
WHERE XAR.ADAPTER_TYPE = XAT.ADAPTER_TYPE
AND XFE.FE_ID = XAR.FE_ID GROUP BY XFE.FE_ID
, XAT.APPLICATION_MODE
, XAT.INBOUND_REQUIRED_FLAG
, XFE.FULFILLMENT_ELEMENT_NAME
, XFE.DISPLAY_NAME