DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_CATEGORIES_KFV

Line 332: From mtl_categories_kfv mck

328: Begin
329:
330: /*
331: Select mcs.category_set_name||' / '||mck.concatenated_segments into l_category_set_name
332: From mtl_categories_kfv mck
333: ,mtl_category_sets_vl mcs
334: ,mtl_category_set_valid_cats mcsvc
335: Where mcs.category_set_id = mcsvc.category_set_id
336: and mck.category_id = mcsvc.category_id

Line 343: FROM MTL_CATEGORIES_KFV mck

339:
340: -- Bug # 3271041
341:
342: SELECT mcs.CATEGORY_SET_NAME||' / '|| mck.CONCATENATED_SEGMENTS into l_category_set_name
343: FROM MTL_CATEGORIES_KFV mck
344: ,MTL_CATEGORIES_VL mc
345: ,MTL_CATEGORY_SETS_VL mcs
346: ,( SELECT mic.ORGANIZATION_ID
347: ,mic.CATEGORY_SET_ID