DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on MTL_ITEM_CATEGORIES

Line 1211: FROM mtl_item_categories mic,

1207: -- Get Item Category ID
1208: -- As in Requisition Import
1209: CURSOR item_category_cur(p_item_id NUMBER, p_destination_org_id NUMBER) IS
1210: SELECT mic.category_id
1211: FROM mtl_item_categories mic,
1212: mtl_default_sets_view mdsv
1213: WHERE mic.inventory_item_id = p_item_id
1214: AND mic.organization_id = p_destination_org_id
1215: AND mic.category_set_id = mdsv.category_set_id