DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 3513: mtl_default_category_sets mdcs where

3509:
3510:
3511: select mic.category_id into l_purch_cat_id
3512: from mtl_item_categories mic,
3513: mtl_default_category_sets mdcs where
3514: mic.inventory_item_id = l_eam_mat_req_rec.inventory_item_id
3515: and mic.organization_id = l_eam_mat_req_rec.organization_id
3516: and mic.category_set_id = mdcs.category_set_id
3517: and mdcs.functional_area_id = 2;

Line 3567: mtl_default_category_sets mdcs where

3563: )then
3564:
3565: select mic.category_id into l_purch_cat_id
3566: from mtl_item_categories mic,
3567: mtl_default_category_sets mdcs where
3568: mic.inventory_item_id = l_eam_mat_req_rec.inventory_item_id
3569: and mic.organization_id = l_eam_mat_req_rec.organization_id
3570: and mic.category_set_id = mdcs.category_set_id
3571: and mdcs.functional_area_id = 2;