DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on MTL_FLEX_CONTEXT

Line 78: FROM mtl_flex_context

74: ELSE
75: BEGIN
76: SELECT descriptive_flex_context_code
77: INTO context_value
78: FROM mtl_flex_context
79: WHERE organization_id = -1
80: AND context_column_name = l_context_column_name
81: AND descriptive_flexfield_name = flex_name
82: AND context_column_value_id = item_id;

Line 95: FROM mtl_flex_context

91: BEGIN
92:
93: SELECT descriptive_flex_context_code
94: INTO context_value
95: FROM mtl_flex_context
96: WHERE organization_id = org_id
97: AND context_column_name = l_context_column_name
98: AND descriptive_flexfield_name = flex_name
99: AND context_column_value_id = item_id;

Line 114: FROM mtl_flex_context mfc,

110: IF context_value IS NULL THEN
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

Line 134: FROM mtl_flex_context mfc,

130: IF context_value IS NULL THEN
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