ERPstuff - Oracle EBS Community

Hi Niletra,

I have also similar requirement, did you find any soluntion.

Thanks
Ramakrishna

I hope following query will help.

SELECT b.concatenated_segments, c.category_set_name
, b.segment1
, b.segment2
FROM apps.mtl_item_categories a
, apps.mtl_categories_kfv b
, apps.mtl_category_sets_vl c
, apps.mtl_system_items_vl d
WHERE a.category_id = b.category_id
AND a.category_set_id ...

Hi,

Can anybody explain what is the difference between Material Reservations and Allocaitons.

Thanks
Ramakrishna

Check the security profile (MO: Security Profile) value is assign to ur responsibility. Then, navigate to HRMS Responsibility -> Security -> Profile and query the security profile value which is attached to ur responsibility and find out how many operating units are assigned to that security profile ...