APPS.BOM_CSTRDICR_XMLP_PKG SQL Statements

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

Line: 8

        SELECT fifst.id_flex_num
        into L_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'
          AND rownum =1
          ORDER BY fifst.id_flex_num;