DBA Data[Home] [Help]

APPS.XTR_XTRMDTRP_XMLP_PKG SQL Statements

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

Line: 15

      SELECT
        CNT
      FROM
        (   SELECT
            count(*) CNT
          FROM
            XTR_MARKET_DATA_INTERFACE
          WHERE RETURN_CODE >= 50
          UNION ALL
          SELECT
            count(*) CNT
          FROM
            XTR_MARKET_DATA_INTERFACE
          WHERE RETURN_CODE < 40
          UNION ALL
          SELECT
            count(*) CNT
          FROM
            XTR_MARKET_DATA_INTERFACE
          WHERE RETURN_CODE = 40 );
Line: 36

      SELECT
        ITEM_NAME,
        SUBSTR(TEXT
              ,1
              ,100) LANG_NAME
      FROM
        XTR_SYS_LANGUAGES_VL
      WHERE MODULE_NAME = 'XTRMDTRP';
Line: 57

    SELECT
      FCPV.USER_CONCURRENT_PROGRAM_NAME,
      FCR.PROGRAM_APPLICATION_ID
    INTO P_REPORT_TITLE,V_APP_ID
    FROM
      FND_CONCURRENT_PROGRAMS_VL FCPV,
      FND_CONCURRENT_REQUESTS FCR
    WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
      AND FCPV.APPLICATION_ID = FCR.PROGRAM_APPLICATION_ID
      AND FCPV.CONCURRENT_PROGRAM_ID = FCR.CONCURRENT_PROGRAM_ID;
Line: 68

    SELECT
      FORM_LEFT_PROMPT
    INTO P_ERRORS_ONLY_LABEL
    FROM
      FND_DESCR_FLEX_COL_USAGE_VL
    WHERE APPLICATION_ID = V_APP_ID
      AND DESCRIPTIVE_FLEXFIELD_NAME = '$SRS$.XTRMDTRP'
      AND SRW_PARAM = 'P_ERRORS_ONLY';