DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on MTL_ITEM_CATEGORIES

Line 115: mtl_item_categories mic

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

Line 135: mtl_item_categories mic

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