APPS.ZX_TCM_CONTROL_PKG dependencies on MTL_CATEGORIES_B

Line 36: l_category_id mtl_categories_b.category_id%type;

32: l_db_status varchar2(1);
33: l_reg_fscType_flag varchar2(1);
34: l_inventory_set varchar2(1);
35: l_category_set_id mtl_category_sets_b.category_set_id%type;
36: l_category_id mtl_categories_b.category_id%type;
37: l_structure_id mtl_category_sets_b.structure_id%type;
38: l_allocated_flag varchar2(15);
39: l_tca_class_category_code hz_class_categories.class_category%type;
40: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;

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