111: BEGIN
112: SELECT descriptive_flex_context_code
113: INTO context_value
114: FROM mtl_flex_context mfc,
115: mtl_item_categories mic
116: WHERE mfc.organization_id = -1
117: AND mic.organization_id = org_id
118: AND mfc.category_set_id = mic.category_set_id
119: AND mfc.context_column_value_id = mic.category_id
131: BEGIN
132: SELECT descriptive_flex_context_code
133: INTO context_value
134: FROM mtl_flex_context mfc,
135: mtl_item_categories mic
136: WHERE mfc.organization_id = org_id
137: AND mfc.organization_id = mic.organization_id
138: AND mfc.category_set_id = mic.category_set_id
139: AND mfc.context_column_value_id = mic.category_id