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 954: FROM mtl_category_sets_b

950: AND inventory_item_id = p_item_id;
951:
952: CURSOR c_default_category IS
953: SELECT default_category_id
954: FROM mtl_category_sets_b
955: WHERE category_set_id = l_category_set;
956:
957: CURSOR c_category_code IS
958: SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')

Line 961: MTL_CATEGORY_SETS_B mcs

957: CURSOR c_category_code IS
958: SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
959: FROM MTL_CATEGORIES_B_KFV mtl,
960: FND_ID_FLEX_STRUCTURES flex,
961: MTL_CATEGORY_SETS_B mcs
962: WHERE mtl.structure_id = mcs.structure_id
963: AND mcs.category_set_id = l_category_set
964: AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
965: AND flex.APPLICATION_ID = 401