DBA Data[Home] [Help]

APPS.XNP_SV_NETWORK$SMS_FE_MAP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 178

      I_QUERY := 'SELECT count(*)' ||
                 substr(ZONE_SQL, I_FROM_POS);
Line: 226

      ZONE_SQL := 'SELECT SFP.SMS_FE_MAP_ID,
                         L_FET.FULFILLMENT_ELEMENT_NAME,
                         L_FEE.FULFILLMENT_ELEMENT_TYPE,
                         SFP.FEATURE_TYPE,
                         SFP.PROVISION_STATUS
                  FROM   XNP_SV_SMS_FE_MAPS SFP,
                         XDP_FES L_FET,
                         XDP_FE_TYPES L_FEE';