select
(select category_concat_segs
from apps.mtl_item_categories_v
where inventory_item_id = msib.inventory_item_id
and organization_id = msib.organization_id
and category_set_name = ‘Tax Category Code Set’) tax_category,
msib.segment1 item_number,
msib.enabled_flag active_status,
msib.description item_description,
msib.attribute4 form_factor,
gcck.segment5 account_segment,
gcck.concatenated_segments GLC,
APPS.GL_FLEXFIELDS_PKG.get_concat_description(gcck.chart_of_accounts_id, gcck.code_combination_id) code_combination_desc,
(select category_concat_segs
from apps.mtl_item_categories_v
where inventory_item_id = msib.inventory_item_id
and organization_id = msib.organization_id
and category_set_name = ‘Service Category’) svc_category,
(select category_concat_segs
from apps.mtl_item_categories_v
where inventory_item_id = msib.inventory_item_id
and organization_id = msib.organization_id
and category_set_name = ‘Offering Type’) offering_type
from apps.mtl_system_items_b msib,
apps.gl_code_combinations_kfv gcck
where 1=1
–and msib.segment1 like ’25.%’
and msib.organization_id = 85
and gcck.code_combination_id = msib.sales_account
order by msib.segment1;
Recommended Posts
