DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_CATEGORIES_KFV

Line 331: From mtl_categories_kfv mck

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

Line 342: FROM MTL_CATEGORIES_KFV mck

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