APPS.BOM_CSTRFICR_XMLP_PKG SQL Statements

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

Line: 5

    SELECT fifst.id_flex_num
    FROM fnd_id_flex_structures fifst
    WHERE fifst.application_id = 401
    AND fifst.id_flex_code = 'MSTK'
    AND fifst.enabled_flag = 'Y'
    AND fifst.freeze_flex_definition_flag = 'Y'
    ORDER BY fifst.id_flex_num;

Line: 49

      SELECT
        REPORT_TITLE,
        COLUMN1,
        COLUMN2,
        COLUMN1_HEADING,
        COLUMN2_HEADING
      INTO L_REPORT_NAME,L_QRY_COLUMN1,L_QRY_COLUMN2,L_COLUMN1_HEADING,L_COLUMN2_HEADING
      FROM
        CST_REPORT_TYPES
      WHERE UNIQUE_ID = UNIQUE_ID1;

Line: 70

        SELECT
          END_USER_COLUMN_NAME
        INTO L_FLEX_COLUMN1_HEADING
        FROM
          FND_DESCR_FLEX_COLUMN_USAGES FLX,
          CST_REPORT_TYPES CRT
        WHERE APPLICATION_ID = FLEXFIELD_APPLICATION_ID
          AND FLX.DESCRIPTIVE_FLEXFIELD_NAME = CRT.DESCRIPTIVE_FLEXFIELD_NAME
          AND UNIQUE_ID = UNIQUE_ID1
          AND ENABLED_FLAG = 'Y'
          AND APPLICATION_COLUMN_NAME = FLEX_COLUMN1;