[Home] [Help]
| Product: | XNS - Service for Communications (obsolete) |
|---|---|
| Description: | Fulfillment element info for customer products in the installed base |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CPFE.ROWID ROW_ID
, CPFE.CP_FE_ID
, CPFE.LAST_UPDATE_DATE
, CPFE.LAST_UPDATED_BY
, CPFE.CREATION_DATE
, CPFE.CREATED_BY
, CPFE.LAST_UPDATE_LOGIN
, CPFE.FE_ID
, CPFE.CUSTOMER_PRODUCT_ID
, CPFE.START_DATE_ACTIVE
, CPFE.END_DATE_ACTIVE
, FE.FULFILLMENT_ELEMENT_NAME
, FE.DISPLAY_NAME CP_FE_NAME
, FET.FULFILLMENT_ELEMENT_TYPE
, FET.DISPLAY_NAME CP_FE_TYPE
, FEP.SW_GENERIC
, FEP.DISPLAY_NAME CP_FE_SW_GEN
, FEP.ADAPTER_TYPE
, FE.MIN_CONNECTION
, FE.MAX_CONNECTION
FROM XNS_CP_FES CPFE
, XDP_FES_VL FE
, XDP_FE_GENERIC_CONFIG FEG
, XDP_FE_TYPES_VL FET
, XDP_FE_SW_GEN_LOOKUP_VL FEP
WHERE CPFE.FE_ID = FE.FE_ID
AND FE.FE_ID = FEG.FE_ID
AND FE.FETYPE_ID = FET.FETYPE_ID
AND FEG.FE_SW_GEN_LOOKUP_ID = FEP.FE_SW_GEN_LOOKUP_ID
AND SYSDATE >= NVL(FE.VALID_DATE
, SYSDATE)
AND SYSDATE <= NVL(FE.INVALID_DATE
, SYSDATE)
AND FEG.START_DATE = (SELECT MAX(FEG2.START_DATE)
FROM XDP_FE_GENERIC_CONFIG FEG2
WHERE FEG2.FE_ID= FE.FE_ID
AND SYSDATE >= FEG2.START_DATE
AND SYSDATE <= NVL(FEG2.END_DATE
, SYSDATE))