DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on MTL_CATEGORY_SETS_B

Line 332: MTL_CATEGORY_SETS_B mcs

328: CURSOR c_category_code IS
329: SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
330: FROM MTL_CATEGORIES_B_KFV mtl,
331: FND_ID_FLEX_STRUCTURES flex,
332: MTL_CATEGORY_SETS_B mcs
333: WHERE mtl.structure_id = mcs.structure_id
334: AND mcs.category_set_id = l_owner_id_num
335: AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
336: AND flex.APPLICATION_ID = 401

Line 992: FROM mtl_category_sets_b

988: AND inventory_item_id = p_item_id;
989:
990: CURSOR c_default_category IS
991: SELECT default_category_id
992: FROM mtl_category_sets_b
993: WHERE category_set_id = l_category_set;
994:
995: CURSOR c_category_code IS
996: SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')

Line 999: MTL_CATEGORY_SETS_B mcs

995: CURSOR c_category_code IS
996: SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
997: FROM MTL_CATEGORIES_B_KFV mtl,
998: FND_ID_FLEX_STRUCTURES flex,
999: MTL_CATEGORY_SETS_B mcs
1000: WHERE mtl.structure_id = mcs.structure_id
1001: AND mcs.category_set_id = l_category_set
1002: AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
1003: AND flex.APPLICATION_ID = 401