6084: substr(l_data_src_type_code, 1, 30),
6085: 0, -- sending list_header_id as 0. -- The index AMS.AMS_LIST_SRC_TYPE_USAGES_U2 has to be dropped from the ODF for this to work correctly.
6086: 'CPAGE',
6087: p_section_citem_id 6088: from dual 6089: where not exists
6090: ( select 'x'
6091: from ams_list_src_type_usages
6092: where list_header_id = 0
[Home] [Help]