72: pa_res_types_b types
73: where types.res_type_code = 'INVENTORY_ITEM'
74: and types.res_type_id = format.res_type_id
75: and exists (select 'Y'
76: from PA_RESOURCE_LIST_MEMBERS rlm
77: where rlm.res_format_id = format.res_format_id);
78: --and rlm.inventory_item_id is not null)
79: EXCEPTION
80: WHEN NO_DATA_FOUND THEN
129: pa_res_types_b types
130: where types.res_type_code = 'ITEM_CATEGORY'
131: and types.res_type_id = format.res_type_id
132: and exists (select 'Y'
133: from PA_RESOURCE_LIST_MEMBERS rlm
134: where rlm.res_format_id = format.res_format_id);
135: --and rlm.item_category_id is not null)
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN