VIEW: APPS.XDP_FE_GENERIC_CONFIG_V

Source

View Text - Preformatted

SELECT a.fe_id fe_id, a.fulfillment_element_name fe_name, a.display_name fe_name_display, b.adapter_type adapter_type, d.display_name adapter_type_display, b.display_name sw_generic_display, c.start_date start_date, c.end_date end_date FROM xdp_fes_vl a, xdp_fe_sw_gen_lookup_vl b, xdp_fe_generic_config c, xdp_adapter_types_vl d WHERE a.fe_id = c.fe_id AND a.FETYPE_ID = b.fetype_id AND b.fe_sw_gen_lookup_id = c.fe_sw_gen_lookup_id AND b.adapter_type = d.adapter_type AND ( (SYSDATE BETWEEN c.start_date AND NVL(c.end_date, SYSDATE + 1)) OR (c.start_date > SYSDATE) )

View Text - HTML Formatted

SELECT A.FE_ID FE_ID
, A.FULFILLMENT_ELEMENT_NAME FE_NAME
, A.DISPLAY_NAME FE_NAME_DISPLAY
, B.ADAPTER_TYPE ADAPTER_TYPE
, D.DISPLAY_NAME ADAPTER_TYPE_DISPLAY
, B.DISPLAY_NAME SW_GENERIC_DISPLAY
, C.START_DATE START_DATE
, C.END_DATE END_DATE
FROM XDP_FES_VL A
, XDP_FE_SW_GEN_LOOKUP_VL B
, XDP_FE_GENERIC_CONFIG C
, XDP_ADAPTER_TYPES_VL D
WHERE A.FE_ID = C.FE_ID
AND A.FETYPE_ID = B.FETYPE_ID
AND B.FE_SW_GEN_LOOKUP_ID = C.FE_SW_GEN_LOOKUP_ID
AND B.ADAPTER_TYPE = D.ADAPTER_TYPE
AND ( (SYSDATE BETWEEN C.START_DATE
AND NVL(C.END_DATE
, SYSDATE + 1)) OR (C.START_DATE > SYSDATE) )