View: XDP_FE_GENERIC_CONFIG_V

Product:	XDP - Provisioning
Description:	This View gives information about current and future software generics
Implementation/DBA Data:	APPS.XDP_FE_GENERIC_CONFIG_V

View Text

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) )

Columns