APPS.INV_MWB_TREE1 dependencies on MTL_MATERIAL_STATUSES_VL

Line 5965: status_id mtl_material_statuses_vl.status_id%TYPE;

5961: ) IS
5962: query_str VARCHAR2(10000);
5963: query_hdl NUMBER;
5964: rows_processed NUMBER;
5965: status_id mtl_material_statuses_vl.status_id%TYPE;
5966: status_code mtl_material_statuses_vl.status_code%TYPE;
5967: i NUMBER := x_tbl_index;
5968: j NUMBER := x_node_value;
5969: serial_control NUMBER;

Line 5966: status_code mtl_material_statuses_vl.status_code%TYPE;

5962: query_str VARCHAR2(10000);
5963: query_hdl NUMBER;
5964: rows_processed NUMBER;
5965: status_id mtl_material_statuses_vl.status_id%TYPE;
5966: status_code mtl_material_statuses_vl.status_code%TYPE;
5967: i NUMBER := x_tbl_index;
5968: j NUMBER := x_node_value;
5969: serial_control NUMBER;
5970: table_required VARCHAR2(300);

Line 6002: query_str := query_str || 'FROM mtl_material_statuses_vl mms ';

5998: END IF ;
5999: -- NSRIVAST, INVCONV, End
6000:
6001: query_str := 'SELECT mms.status_id, mms.status_code ';
6002: query_str := query_str || 'FROM mtl_material_statuses_vl mms ';
6003: query_str := query_str || ' WHERE exists (';
6004:
6005: IF inv_mwb_globals.g_organization_id IS NOT NULL
6006: AND inv_mwb_globals.g_inventory_item_id IS NOT NULL THEN