APPS.CZ_FCE_COMPILE_DEBUG SQL Statements

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

Line: 529

  FOR file IN (SELECT component_id, fce_file_type, segment_nbr, fce_file FROM cz_fce_files
                WHERE deleted_flag = '0'
                  AND component_id IN
                    (SELECT component_id FROM cz_model_ref_expls WHERE deleted_flag = '0'
                        AND model_id = p_model_id)
                ORDER BY component_id, fce_file_type, segment_nbr ) LOOP

       debug ( '>');