APPS.WIP_WIPDJPCK_XMLP_PKG SQL Statements

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

Line: 6

  select id_flex_num_cl

into item_id_flex_num

from(

SELECT fifst.id_flex_num id_flex_num_cl

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 )

where rownum<2 ;