DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 100: fnd_id_flex_structures flex

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
104: and flex.ID_FLEX_CODE = 'MCAT'

Line 127: fnd_id_flex_structures flex,

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
131: where mtl.structure_id = l_structure_id