APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_FLEX_CONTEXT

Line 2245: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;

2241: v_segments fnd_dflex.segments_dr;
2242: l_attributes_default_count NUMBER;
2243: l_enabled_attributes NUMBER;
2244: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2245: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
2246: v_colname VARCHAR2 (50);
2247: l_context_value VARCHAR2 (150);
2248: l_return_status VARCHAR2 (1);
2249: l_msg_data VARCHAR2 (255);

Line 2986: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;

2982: v_segments fnd_dflex.segments_dr;
2983: l_attributes_default_count NUMBER;
2984: l_enabled_attributes NUMBER;
2985: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2986: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
2987: v_colname VARCHAR2 (50);
2988: l_context_value VARCHAR2 (150);
2989: l_return_status VARCHAR2 (1);
2990: l_msg_data VARCHAR2 (255);

Line 5602: FROM mtl_flex_context

5598: BEGIN
5599:
5600: SELECT descriptive_flex_context_code
5601: INTO l_context_value_item
5602: FROM mtl_flex_context
5603: WHERE organization_id = p_org_id
5604: AND context_column_name = 'ITEM'
5605: AND descriptive_flexfield_name = 'Serial Attributes'
5606: AND context_column_value_id = p_item_id;

Line 5616: FROM mtl_flex_context

5612:
5613: BEGIN
5614: SELECT descriptive_flex_context_code
5615: INTO l_context_value_to_item
5616: FROM mtl_flex_context
5617: WHERE organization_id = p_org_id
5618: AND context_column_name = 'ITEM'
5619: AND descriptive_flexfield_name = 'Serial Attributes'
5620: AND context_column_value_id = p_to_item_id;