APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_FLEX_CONTEXT

Line 2296: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;

2292: v_segments fnd_dflex.segments_dr;
2293: l_attributes_default_count NUMBER;
2294: l_enabled_attributes NUMBER;
2295: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2296: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
2297: v_colname VARCHAR2 (50);
2298: l_context_value VARCHAR2 (150);
2299: l_return_status VARCHAR2 (1);
2300: l_msg_data VARCHAR2 (255);

Line 3027: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;

3023: v_segments fnd_dflex.segments_dr;
3024: l_attributes_default_count NUMBER;
3025: l_enabled_attributes NUMBER;
3026: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3027: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
3028: v_colname VARCHAR2 (50);
3029: l_context_value VARCHAR2 (150);
3030: l_return_status VARCHAR2 (1);
3031: l_msg_data VARCHAR2 (255);

Line 5631: FROM mtl_flex_context

5627: BEGIN
5628:
5629: SELECT descriptive_flex_context_code
5630: INTO l_context_value_item
5631: FROM mtl_flex_context
5632: WHERE organization_id = p_org_id
5633: AND context_column_name = 'ITEM'
5634: AND descriptive_flexfield_name = 'Serial Attributes'
5635: AND context_column_value_id = p_item_id;

Line 5645: FROM mtl_flex_context

5641:
5642: BEGIN
5643: SELECT descriptive_flex_context_code
5644: INTO l_context_value_to_item
5645: FROM mtl_flex_context
5646: WHERE organization_id = p_org_id
5647: AND context_column_name = 'ITEM'
5648: AND descriptive_flexfield_name = 'Serial Attributes'
5649: AND context_column_value_id = p_to_item_id;