[Home] [Help]
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
Name |
FE_ID |
FE_NAME |
FE_NAME_DISPLAY |
ADAPTER_TYPE |
ADAPTER_TYPE_DISPLAY |
SW_GENERIC_DISPLAY |
START_DATE |
END_DATE |