DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on MTL_CATEGORIES_B_KFV

Line 99: from mtl_categories_b_kfv mtl,

95:
96: -- get the category id for the category code
97: cursor c_category is
98: select mtl.category_id
99: from mtl_categories_b_kfv mtl,
100: fnd_id_flex_structures flex
101: where mtl.structure_id = l_structure_id
102: and flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
103: and flex.APPLICATION_ID = 401

Line 126: from mtl_categories_b_kfv mtl,

122: and mit.organization_id = p_fsc_rec.item_org_id
123: and mit.inventory_item_id = p_fsc_rec.classified_entity_id
124: and exists (
125: select mtl.category_id
126: from mtl_categories_b_kfv mtl,
127: fnd_id_flex_structures flex,
128: ( select start_position, num_characters
129: from zx_fc_types_b
130: where classification_type_code = p_fsc_rec.classification_type) fc